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 Notice: Undefined offset: 1 (Array)
• How to Sleep/Wait/Pause on a NodeJs Function
• How to Run a NodeJs Script
• How to Install a Module/Package/Library in NodeJs
• NodeJs Request.Get Example with Error Handling
• NodeJs HTTPS.Get Example with Error Handling
• How to Find PHP.ini Location
• How to Enable Display of Errors in PHP

Updated Posts

• Detect a failing hard-disk on a Linux server
• Certbot.errors.CertStorageError: expected to be a symlink
• Example hard-disk error logs on a Linux server
• Certbot renew error: Account at does not exist.
• Suspicious online shops from helpandserving@gmail.com
• Nginx Rewrite Rule to Add Slash to The End of Any URL
• Compress Word, Excel and PowerPoint Office Documents
• Download OpenVPN 2.4.7 and TAP-Windows