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 Display Date Same as Server HTTP Headers Date
• Google Cloud Load Balancer Firewall Rules
• Create Instance Template out of Disk Snapshot on Google Cloud
• Get User IP Address From Google Cloud Load Balancer
• Connect as Root using WinSCP on Google Cloud Compute Engine
• Become Root on Google Cloud Compute Engine VMs
• Connect to Google Cloud Compute Engine VM via PuTTY SSH
• DigitalOcean Slow, My Experience

Updated Posts

• PHP GetHostByAddr() Slow? Make it Faster
• PHP GetHostByName() Slow? Make it Faster
• How to Match Newline with Strpos() in PHP
• Use PHP Strpos() to Check if a String Starts with
• How to Run a Command with Time Limit in Bash Linux
• Unable to extract and upload PackageInfo.xml
• Stop Bad Bots from Crawling Your Website
• DEB.SURY.ORG Updated the Signing Key (March 2019)