Wed, May 13, 2015

Moving MySQL data directory to another disk

 

If you’re moving the MySQL data directory to another disk or partition on CentOS or RedHat and MySQL fails to start or read any data (Can’t read dir x error in the error log), it’s probably two things.

  • mysql:mysql should be the ownership of the directory (chown -R mysql.mysql your_dir)
  • SELinux is preventing the read. You should either disable SELinux completely (not recommended) or make it aware of the change.

« The occasional blog