How to Safely Change the MySQL Data Directory?

Change MySQL Data Directory: Relocating Your Databases

To modify the default MySQL data directory, it is crucial to follow a series of steps to ensure a seamless transition and maintain database accessibility.

1. Halt MySQL Services:
   Start by stopping MySQL using the command:

   sudo /etc/init.d/mysql stop

   Copy after login

2. Data Directory Replication:
   Duplicate the existing data directory, typically located at /var/lib/mysql, to the new desired location:

   sudo cp -R -p /var/lib/mysql /newpath

   Copy after login
3. MySQL Configuration File Editing:
   Edit the MySQL configuration file, usually /etc/mysql/my.cnf, and modify the 'datadir' entry to reflect the new data directory's path.
4. Modifying AppArmor Profiles:
   In /etc/apparmor.d/usr.sbin.mysqld, locate lines beginning with /var/lib/mysql and update them with the new path.

5. Restart AppArmor:
   Reload the AppArmor profiles using the command:

   sudo /etc/init.d/apparmor reload

   Copy after login

6. MySQL Service Restoration:
   Restart MySQL:

   sudo /etc/init.d/mysql restart

   Copy after login
7. MySQL Login Verification:
   Log in to MySQL to confirm access to existing databases.

By completing these steps, you can successfully relocate MySQL's data directory to a new path while maintaining access to your databases.

The above is the detailed content of How to Safely Change the MySQL Data Directory?. For more information, please follow other related articles on the PHP Chinese website!