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

• Download Latest Raspbian ISO for Raspberry Pi
• What is Default Raspbian Raspberry Pi Password
• How to Install Pi-Hole on Raspbian for Raspberry Pi
• 3 Cards in a Row with Bootstrap 4.4
• Debug 502 Errors in Google Cloud Load Balancer
• Python if-then-else in one line example
• How to urlencode() an URL in Python3
• Install Required Fonts for Puppeteer

Updated 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