How do you programmatically create an empty database?
jonathandlynch at gmail.com
Tue Nov 23 16:24:47 EST 2010
I am not talking about a database on a server. I just want to create a
database file on a shared drive. Would I still need to use a shell command
On Tue, Nov 23, 2010 at 4:17 PM, Mark Schonewille <
m.schonewille at economy-x-talk.com> wrote:
> Hi Jonathan,
> You need to connect to the SQL server using the terminal (i.e. the shell
> function), login as root and execute the command to create the database. It
> is also possible to write a PHP script and have it create the database, if
> you are connecting to a web server. Sometimes you need to do all of this
> over SSH. Depending on your setup, it might be easy or impossible. Perhaps
> we can figure that out if you provide more info.
> Since usually you need to do this only once, it is easier to create the
> database manally. Once the database itself has been created, you can create
> all tables and fields by means of a script from RunRev.
> Best regards,
> Mark Schonewille
> Economy-x-Talk Consulting and Software Engineering
> Homepage: http://economy-x-talk.com
> Twitter: http://twitter.com/xtalkprogrammer
> KvK: 50277553
> How to receive a free Color Converter license http://qurl.tk/kv (read the
> On 23 nov 2010, at 22:09, Jonathan Lynch wrote:
> > I have been looking through the docs, and this does not seem obvious to
> > I see that opening a nonexistent database using the SQlite driver will
> > create one - but that only applies to SQLite.
> > It would seem that the standard way to do this, would be to use
> > revExecuteSql, but that command requires having a database ID, which
> > mean that the database would need to already exist.
> > I apologize for my complete ignorance of database lore.
> > Thanks,
> > J
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
Do all things with love
More information about the Use-livecode