Changing the data storage path in Linux MySQL

To change the data storage path, you must first modify the configuration, copy the data, and then restart.

1. to ensure data accuracy, it is best to stop the MySQL service or lock MySQL table writes.

/Etc/My. CNF

[Mysqld]
Datadir =/var/lib/MySQL
Socket =/var/lib/MySQL. Sock
User = MySQL

Assume that the new data storage path is/data/mysqldata.

Modify the configuration:

[Mysqld]
# Datadir =/var/lib/MySQL
Datadir =/data/mysqldata
Socket =/var/lib/MySQL. Sock
User = MySQL

2. Copy all the original data to the new path.

CP-A/var/lib/MySQL/*/test/MySQL/data/

3. Change the new path host

Chown MYSQL: MySQL/test/MySQL/Data

4. Restart MySQL service/sbin/service mysqld restart

Note: If you use Amazon cloud, do not use the MySQL path provided by ordinary EBS, And the search speed slows down.