WHM Move MySQL Data Folder

move-mysql-data.md

1. Make a full mysqldump file

mysqldump --all-databases | gzip > /home/alldatabases.sql.gz

2. Uncheck monitor in WHM > Service Manager for Mysql and save the area.

3. Stop MySQL

/etc/init.d/mysql stop

4. Make the directory for MySQL in /home, move it and symlink it

mkdir /home/var_mysql
mv /var/lib/mysql /home/var_mysql
chown -R mysql:mysql /home/var_mysql/mysql
ln -s /home/var_mysql/mysql /var/lib/mysql
/etc/init.d/mysql start

5. Re-check monitor in WHM > Service Manager for MySQL and save the area

If anything goes wrong, you have the full mysqldump backup, and can use these steps to restore from it: First, you'll need the MySQL root password:

cat /root/.my.cnf

Once you have the password, then you can use this command to restore from that file:

gunzip < /home/alldatabases.sql.gz | mysql -u root -p

You'll be asked for the password here, so simply enter the one noted in /root/.my.cnf location.

Refrence: https://forums.cpanel.net/threads/how-to-move-mysql-data-directory.110481/post-709306