Thanks, Mark. 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 for that?
On Tue, Nov 23, 2010 at 4:17 PM, Mark Schonewille < m.schonewi...@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 > conditions) > > On 23 nov 2010, at 22:09, Jonathan Lynch wrote: > > > I have been looking through the docs, and this does not seem obvious to > me. > > > > 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 > would > > 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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- Do all things with love _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
