Posted on May 20, 2017 at 6:50 pm

You can restore a previously copied\moved MySQL datadir on a new server:

1) Stop the MySQL service

service mysql stop

2) Rename the actual MySQL datadir to something different:

mv /var/lib/mysql /var/lib/mysql_original

3) Copy the MySQL datadir to restore in the MySQL datadir path:

cp -R /backups/mysql /var/lib

4) Set mysql:mysql permissions to the new /var/lib/mysql directory:

chown -R mysql:mysql /var/lib/mysql

5) Start the MySQL service

service mysql start

6) If all went well, remove /var/lib/mysql_original:

rm -rf /var/lib/mysql_original

Other Posts

• Bash Get the size of a file
• Crontab requires escaping any % signs
• Bash Check folder size Linux
• Bash remove the first line of a large file
• ERROR 1114 (HY000): The table 'site' is fullage done
• Get Linux Server Unique Machine ID
• Linux make files accessible only by root
• Bash Autologin with MySQL MariaDB server

Updated Posts

• Backup MySQL datadir without Mysqldump
• Import MySQL Database from CommandLine
• Delphi 10 Berlin System.Hash MD5 SHA1 SHA2 Hash
• Standard ISO paper sizes, DPI and images size
• Download Google Chrome Full Standalone Offline Installer
• PHP cURL curl_getinfo() Output
• PHP cURL Get Redirect URL as Variable
• Upload a File via POST with cURL and PHP 7