MySQL 8 Cookbook

How to do it...

1. Stop the MySQL server:

 shell> sudo systemctl stop mysql

2. Move the files to the data directory:

 shell> sudo mv /backup/mysql /var/lib

3. Change the ownership to mysql:

 shell> sudo chown -R mysql:mysql /var/lib/mysql

4. Start MySQL:

 shell> sudo systemctl start mysql

To minimize the downtime, if you have enough space on disk, you can copy to the backup to /var/lib/mysql2. Then stop MySQL, rename the directory, and start the server:

shell> sudo mv /backup/mysql /var/lib/mysql2shell> sudo systemctl stop mysqlshell> sudo mv /var/lib/mysql2 /var/lib/mysqlshell> sudo chown -R mysql:mysql /var/lib/mysqlshell> sudo systemctl start mysql