Detailed introduction to the method of modifying the mysql data directory under Win2008 r2

In 2008InstallationmysqlI found that the database directories are all placed on the c drive, which is not safe for the data. The c drive is only placed System, quickly change the mysql directory, otherwise data loss will be in trouble

Change the defaultmysql databaseDirectory

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

1. Create the folder D:\MysqlData

2. Stop the mysql service and change "C:\ProgramData\MySQL Server 5.1\data" Copy all files to D:\MysqlData

3. Find the my.ini file in the mysql installation directory and find:

#Path to the database root
#data
dir
="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 "Don't show hidden files..." in the file options

The above is the detailed content of Detailed introduction to the method of modifying the mysql data directory under Win2008 r2. For more information, please follow other related articles on the PHP Chinese website!