Re: location of created database

2004-05-28 Thread Lou Olsten
op the server, move the directories, change the datadir to the new location, then restart... I've not done this, so someone else may want to confirm. Lou - Original Message - From: "Bono, Saroj AA R62" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday,

Re: location of created database

2004-05-28 Thread gerald_clark
Bono, Saroj AA R62 wrote: When I created a database (directly in mysql) from some random dir where I started mysql, I found that it got created in the /var/lib/mysql dir. I ran mysql from a dir where my C++ program is. I wanted to create a database using mysql_query so I did mysql_query( &mysql,

location of created database

2004-05-28 Thread Bono, Saroj AA R62
When I created a database (directly in mysql) from some random dir where I started mysql, I found that it got created in the /var/lib/mysql dir. I ran mysql from a dir where my C++ program is. I wanted to create a database using mysql_query so I did mysql_query( &mysql, "CREATE DATABASE IF NOT E