Moving mysql query .....

[rab54]

Howdy guys -

OK I have our mysql db on the c: - but due to it's increasing size I have been asked to move it to the d: drive ....

I am on Win2k3 so is it just a case of moving the data over or will I have to re-install mysql onto the d: drive and then move the data over -

Any advice would be appreciated

cheers

Rab

 

[TonyGroves]

If you just want to move the data over, then all you have to do is move the data directory (c:\mysql\data or whatever) to d: (d:\mysqldata or whatever), and edit your configuration file (c:\my.cnf or c:\winnt\my.ini) so that the section headed [mysqld] contains the entry datadir=d:/mysqldata (or whatever).

-----
ALTER world DROP injustice, ADD peace;