471,073 Members | 1,318 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Location of databases

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
Jul 19 '05 #1
2 1802
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
Jul 19 '05 #2
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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Kamlesh | last post: by
4 posts views Thread by Laurence | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.