Bono, Saroj AA R62 wrote:
You don't. All mysql databases for a specific server must appear in its database directory.
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 EXISTS abc"). THis didnt create anything. If it did
would it be created in the /var/lib location ?I want to create it in my
local dir (when I do get my syntax to work!). How do I tell mysql to
make the database in some specific location? Thanks.
You can, however stop the server, move the database and create a symbolic link in /var/lib/mysql
that points to it.
Why do you want to do this? It sounds like a potential administration nightmare.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
