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

• Route OpenVPN Connections Through Floating IP
• How to Configure a Floating IP in a VPS (Hetzner)
• Set OpenVPN to Listed on a Specific IP Address
• Bash Trim Leading and Trailing Whitespace from a String
• Bash Get Name of Ethernet Network Interface
• VPN Providers with Dedicated Static IP Address
• OpenVPN Iptables Rules
• WireGuard VPN Iptables Rules

Updated Posts

• AMD Chipsets & Graphics Card Drivers for Windows 7, 8, 10
• AMD Radeon 7400 Drivers for Windows 10
• How to pass custom command-line parameters in InnoSetup
• Add Desktop shortcut for all Windows PC users
• Programmatically create desktop icon with InnoSetup
• GeneratePress - a Lightweight WordPress Theme 2021
• InnoSetup disable DesktopIcon via command-line
• Use cURL to authenticate with JWT Bearer tokens