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

• Customer emails don't show up in Zendesk
• Get Windows 7, 8, 10 License Information
• Cheapest Alternatives to Mailchimp, Sendinblue, Sendgrid
• Convert InnoSetup EXE Installer to MSI
• Get Serial Number of CPU, RAM, Motherboard, HDD
• Get Number of Intel Processor Cores via Registry
• Zendesk Remove [Business Name] from Email Subject on Ticket Replies
• Best Text-to-Speech (TTS) Web Services with Human Voices

Updated Posts

• Exclude Packages from Apt-Get Upgrade on Debian Linux
• Should I reboot Debian server after apt-get upgrade?
• Download and Install OpenVPN Client on Windows 10
• How to List All Iptables NAT Rules
• How to List INPUT, FORWARD, OUTPUT Iptables Rules
• OpenVPN Iptables Rules
• Parse or Split FTP URL in Delphi XE using TIdURI
• Public FTP Server to Test Upload and Download