Change MySQL data file storage path in Linux

A lot of times, MySQL data will be very large, the data by default in the/var/lib/mysql, because the/var divided the space is not big enough, so we need to change the MySQL data storage path, put it into the large partition, in order to be able to cope with the MySQL data growth.

1. Set up a new storage path

Mkdir-p/data/mysql

2. Copy existing data

Cp-r/var/lib/mysql/*/data/mysql

3. Modify Permissions

Chown-r Mysql:mysql/data/mysql

4. Modify the configuration file

VI/ETC/MYSQL/MY.CNF
    DataDir =/data/mysql

5. Modify Startup file

Vi/etc/apparmor.d/usr.sbin.mysqld

#把

/var/lib/mysql R,
    /var/lib/mysql/** Rwk,

#改成

/data/mysql R,
    /data/mysql/** Rwk,

6. Restart Service
Restart AppArmor

/etc/init.d/apparmor Restart
    /etc/init.d/mysql restart

This modification is complete.