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

• Edit /etc/hosts on Mac OSX
• Set $_SERVER['REQUEST_URI'] when running PHP script from terminal
• View All Available Code Sign Certificates on USB Token
• Close program with ESC key in Delphi
• Create a Custom Mount Point with Noexec on Debian
• How to Secure /tmp and /var/tmp on your VPS
• IP anonymization with analytics.js - Google Analytics
• IP anonymization with gtag.js - Google Analytics

Updated Posts

• Integrate Disqus on WordPress programmatically
• Disable Compression when Encrypting with GNU GPG
• ERROR 1932 (42S02): Table doesn't exist in engine
• Minify & Compress CSS with online tools
• Unminify CSS and Javascript with online tools
• SMS messages from 1-410-200-500 are a scam
• Email addresses associated with suspicious online shops
• Suspicious online shops from helpandserving@gmail.com