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

• How to List All Iptables NAT Rules
• Parse or Split FTP URL in Delphi XE using TIdURI
• How to Download a File via FTP in Delphi XE
• Public FTP Server to Test Upload and Download
• How to Parse Command-Line Arguments in Bash
• How to Make Iptables Rules Persistent
• Bash Install Iptables-Persistent Automatically
• Route OpenVPN Connections Through Floating IP

Updated Posts

• How to fix "Clickable elements too close together"
• How to fix "Text too small to read"
• Create Custom Rest Endpoints for WP Rest API
• Timestamp URLs for SHA1 SHA256 Code Sign 2021
• PHP Multi-cURL to Run Parallel cURL Requests (Example)
• The following signatures were invalid: EXPKEYSIG B188E2B695BD4743
• Best Clean Monospace Web Fonts 2021
• Add New Path to Delphi 10.4 Sydney on Library Path