Posted on January 21, 2018 at 5:23 pm

When you move MySQL databases from datadir /var/lib/mysql/ to another server, remember to also copy the file /etc/mysql/debian.cnf to the new server, it contains the password used to connect to MySQL server via command-line. Very important if you use automated backups.

Just a quick tutorial to move a MySQL database:

1) Stop MySQL server: /etc/init.d/mysql stop
2) Copy datadir /var/lib/mysql/ to another server or location
3) Copy also /etc/mysql/debian.cnf to the new server
4) Start MySQL server: /etc/init.d/mysql start

Other Posts

• PHP Generate Secure Random Passwords
• Google Cloud SQL and Public IP Address Security
• How to use Highlight.js to highlight code
• Nginx HTTP to HTTPS and non-www to www behind Google Load Balancer
• Quota 'IN_USE_ADDRESSES' exceeded. Limit: 8.0 in region
• Only allow Google Load Balancer traffic (Firewall Rules)
• Lost connection during Debian apt-get upgrade
• Bootstrap 3 Navbar with Logo Image

Updated Posts

• PHP StrToTime() Returns Incorrect Timestamp '-1 MONTH'
• PHP Correctly Get Last 12 Months (Month per Month)
• Nginx Redirect From a Website to Another Website
• PHP Multi-cURL to Run Parallel cURL Requests (Example)
• Let's Encrypt on Nginx and SSL Grade A+
• Vertically align Facebook and Twitter share buttons
• Download Windows 10 ISO without Media Creation Tool
• DEB.SURY.ORG Updated the Signing Key (March 2019)