MySQL: how to change the data location

Question

I use MySQL 5.2.36 CE. When I installed it, the software was installed to

C:\Program Files (X86)\MySQL

The database location was given to

D:\ABC\MySQL

I am hoping to change the database location to

D:\DEF\MySQL

Any quick way do it? I use a Windows 7 pro 64-bit machine.

Thanks and regards.

score 1 · Answer 1 · answered May 11 '15 at 22:19

1

Shutdown mysql, move the data directory to the new location, open my.cnf and change the value of "datadir" to the new path.

answered May 11 '15 at 22:19

AcidReign

and don't forget to restart mysql – AcidReign May 11 '15 at 22:19
Thanks for help! Cannot find my.cnf file in Windows 7. – curious1 May 12 '15 at 00:22

1 Answers1