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

• SMS messages from 1-410-200-500 are a scam
• "Google FREE Apple iPhone X Visitor Browser Opinion Survey" Scam
• Linux Client Tools that Support TLS (GnuTLS, OpenSSL, Socat, Ncat, Telnet-SSL)
• How to create a 1GB random file in Linux
• Prevent less from Clearing the Screen upon Exit on Linux
• Open User's Home Directory from Command-Line on Windows
• Open User's Desktop Directory from Command-Line on Windows
• Delete a Junction from Command-Line on Windows

Updated Posts

• Improve TP-Link TL-MR6400 WiFi Download Speed
• Best Software Licensing Services to License Your Apps
• Merge Two Redis Databases via PHP
• How to Connect to Redis Database via PHP
• PHP Shell_Exec() Get Complete Output as String
• How to Install OpenSSH SSHD Server on Debian Linux
• Download Windows 10 October 2018 Update 1809 ISO Files (Official)
• Download Windows 10 19H1 Build 18252 ISO Images