Mysql – delete after moving MySQL database files location

MySQL

I'm trying to move the location of database files from /var/lib/mysql to /home/lib/mysql

I only changing database files. Socket is still /var/lib/mysql/mysql.sock (only changing datadir in my.cnf)

Now, all data in /var/lib/mysql has been copied to /home/lib/mysql

MySQL has been started and everything is fine. Now time to cleaning up data in /var/lib/mysql

but I'm not sure what data can and cannot be removed in /var/lib/mysql

this is data (except database name) in /var/lib/mysql:

ibdata1
ib_logfile0
ib_logfile1
mysql

Best Answer

After successfully moving your data dir, you can just delete the whole folder and its files/subfolder.

$sudo rm -rf /var/lib/mysql

You just need to double-check you have all the data.

Related Topic