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]

Re: Location of databases

In article <voe3rh3fb4pl73 @corp.supernews .com>, fblair4@ev1.net says...[color=blue]
> 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
>
>
>[/color]

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_prepare_environment.html

[Toshi1873]

Re: Location of databases

In article <voe3rh3fb4pl73 @corp.supernews .com>, fblair4@ev1.net says...[color=blue]
> 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
>
>
>[/color]

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_prepare_environment.html