How to implement Mysql switching data storage directory

How to implement Mysql switching data storage directory

Today, I encountered at work that the partition space where mysql is stored has been used up, resulting in mysql being unable to start normally. For this reason, I had to migrate the data storage directory.

1. Transfer the existing data storage directory to another storage space. Today, it took more than 30 minutes to copy a 50G data file, which was a bit slow.

2. Modify the my.cf configuration file

Modify the storage directory

[mysqld]

datadir=/home/mysql

socket=/home/mysql/mysql.sock

[mysql_safe]

pid-file=/home/mysql/mysqld.pid

Added

[mysql]

socket=/home/mysql/mysql.sock

3. Be sure to pay attention to modifying the permissions of the data storage directory, especially when

mysql_safe pid home/mysql/mysqld.pid* ended Similar exceptions

Thank you for reading, I hope it can help you, thank you for your support of this site!