Change the Ubuntu MySQL Data directory location

Change the Ubuntu MySQL Data directory location

Most of the time, MySQL data will be very large, the data by default in/var/lib/mysql, because/var partition space is not large enough, so we need to change the MySQL data storage path, put into the large partition, so that can cope with MySQL data growth.

1. Set a new storage path

1. Mkdir-p/data/mysql

2. Copy the original data

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

3. Modify Permissions

1. Chown-r Mysql:mysql/data/mysql

4. Modify the configuration file

1. Vim/etc/mysql/my.cnf
2. DataDir =/data/mysql

5. Modify the Startup file

1. Vim/etc/apparmor.d/usr.sbin.mysqld

#把

1. /var/lib/mysql R,
2. /var/lib/mysql/** Rwk,

#改成

1. /data/mysql R,
2. /data/mysql/** Rwk,

6. Restart the service

Restart AppArmor

1. /etc/init.d/apparmor restart
2. /etc/init.d/mysql restart

Turn from: High-feed blog

Change the Ubuntu MySQL Data directory location