The method of modifying MySQL data directory under Win2008 R2 _win server

Change the default MySQL database directory

Change the C:\ProgramData\MySQL\MySQL Server 5.1\data to D:\MysqlData

1. Create a folder D:\MysqlData

2. Stop MySQL service, copy "C:\ProgramData\MySQL Server 5.1\data" All files to D:\MysqlData

3. Locate the My.ini file in the MySQL installation directory and find:

#Path to the database root
#datadir = "C:/programdata/mysql/mysql Server 5.1/data/"

Change the value of DataDir to: datadir= "d:/mysqldata/"

After saving, restart the MySQL service.

Note: The C:\ProgramData directory is a hidden folder, you can uncheck the file option "Do not show hidden files ..."