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?
Yes.
>
>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
this query:
SHOW VARIABLES LIKE 'datadir'
For the installation directory, use 'basedir' rather than 'datadir'.
>
>Thanks
>
>Carlin
>> 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.
>> Hth,
>> Arthur
>>
>> -----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
>> have
>> the need to create a second database under the mysql implementation. Is
>> there
>> a way that i can create this second database via an ODBC object, or do I
>> need
>> to at least specify the database be created as part of the conversion
>> process?
>>
>>
>> Thanks
> > Carlin Anderson
