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

• How to Disable Hibernation on Windows 10
• Disable Windows Defender on Windows 10 via Regedit
• Install Latest NVIDIA Drivers for Windows 10
• How to improve security of encrypted hard disks
• Get Server IP Address with Ifconfig and IP in Bash
• bash: ipconfig: command not found
• Check if a number is within a range in bash
• Linux Commands to Check HDD from Rescue Mode

Updated Posts

• Double Opt-in Email Newsletter Made Right (by Yoast)
• Let's Encrypt on Nginx and SSL Grade A+
• Free Email Ticketing Systems for Startups
• Delphi URLEncode like PHP
• Delphi Function to Parse JSON Unicode Chars
• Ask Users What Features They Need (Product Roadmap)
• Make Your Domain Emails Not Spoofeable
• Create Documentations Easily with GitBook