At 16:40 +0000 2/13/03, cjanders@stripped wrote:
>If that is done with the engine already running, will the DB be recognized
>without a restart?
>Also - do you happen to know if I am able to determine where the mysql/data
>directory resides from a given DB connection? It will not always be the same
>location for the different installs that are going to be converted.
You can ask the server to tell you its data directory location by issuing
SHOW VARIABLES LIKE 'datadir'
For the installation directory, use 'basedir' rather than 'datadir'.
>> It's dead simple to create a MySQL database -- it's just a directory under
>> mysql\data. If you want to do it from Access, just determine where the
>> mysql\data directory is and then create the subdirectory.
>> -----Original Message-----
>> From: cjanders@stripped [mailto:cjanders@stripped]
>> Sent: February 13, 2003 9:01 AM
>> To: mysql@stripped
>> Subject: Create database via ODBC
>> I have an application which is being converted from access to mysql, and
>> the need to create a second database under the mysql implementation. Is
>> a way that i can create this second database via an ODBC object, or do I
>> to at least specify the database be created as part of the conversion
> > Carlin Anderson