change the datadir

[spookie]

Hi,

I have installed MySQL on windows2k. The present path of datadir is c:\mysql\data. Now i want the data to be located somewhere in d:.
Is it possible without uninstalling the MySQL server ?
can i just edit my.ini for datadir and also when i edit the my.ini file shd the mysql server be running or not ?
Any guidance is much helpfull.
Thanks in advance

cheers

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[sleipnir214]

To make a change that drastic in MySQL's configuration, I recommend that you shut down MySQL first.

You can change the data directory by editing my.cnf. Just make sure that the new data directory exists, that the old data subdirectories are in place and that the permissions of the new directory match the permissions of the old directory before you try to restart MySQL.

Want the best answers? Ask the best questions

TANSTAAFL!!

 

[spookie]

Thanks for the help sleipnir214 !!

I will try that out

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.