Location of databases

[Fred Blair]

In my default installation, it creates a folder for 'data' under c:\mysql .
If I want the data to reside under my local internet root directory, how do
I tell Mysql where to find it?

Fred

[Toshi1873]

In article <vo************@corp.supernews.com>, fb*****@ev1.net says...

In my default installation, it creates a folder for 'data' under c:\mysql .
If I want the data to reside under my local internet root directory, how do
I tell Mysql where to find it?

Fred

Edit your my.cnf or my.ini file... there will be up to half a dozen
different paths that you'll have to change (3 are InnoDB specific if
you're using the InnoDB table types).

http://www.mysql.com/doc/en/Windows_...vironment.html

[Toshi1873]

In article <vo************@corp.supernews.com>, fb*****@ev1.net says...

In my default installation, it creates a folder for 'data' under c:\mysql .
If I want the data to reside under my local internet root directory, how do
I tell Mysql where to find it?

Fred

Edit your my.cnf or my.ini file... there will be up to half a dozen
different paths that you'll have to change (3 are InnoDB specific if
you're using the InnoDB table types).

http://www.mysql.com/doc/en/Windows_...vironment.html