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

• Detect VMWare Virtual Machine
• Detect Microsoft Virtual PC Virtual Machine
• Fix MariaDB 10.5 "Can't create test file" errors
• Use MariaDB and MySQL without Password (MySQL Backup)
• Check if a Trademark is already registered
• Make name server address permanent in /etc/resolv.conf
• InnoSetup error the servicemanager is not available
• InnoSetup disable DesktopIcon via command-line

Updated Posts

• Delphi 10 Berlin System.Hash MD5 SHA1 SHA2 Hash
• Use cURL to check for SSL certificate issues:
• How to test Socks5 proxy with cURL
• How to use variables in a sed command
• Best Socks5 Servers for Linux Debian
• Error NO_PUBKEY in Google Cloud Debian Packages Update
• How to Run a Command with Time Limit in Bash Linux
• MySQL InnoDB log sequence number is in the future