MySQL database file migration and modify default data file storage location

Environment:

1. Two WIN10 computers

2, MySql5.6

Process:

1, the original computer to stop the MySQL service

2. Copy the C:\ProgramData\MySQL\MySQL Server 5.6\data folder to the target computer D:\MysqlData

3, the target computer to stop the MySQL service

4. Modify the target computer C:\Program files (x86) \mysql\mysql Server 5.6\my.ini file:

DataDir instead:

Datadir= "d:/mysqldata/data/"

5. Target PC d:/mysqldata/data/Set authenticated user and users Full Control permissions

6, the target computer to start the MySQL service

MySQL database file migration and modify default data file storage location