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

• Block Paltalk Ads (and Others) via Hosts file
• E: Sub-process /usr/bin/dpkg returned an error code (2)
• How to Validate JSON in PHP
• The program can’t start because VCRUNTIME140.DLL is missing
• PHP CURL Download Remote URL to File
• PHP Check if a file was modified more than 1 hour ago
• Linux -bash: Input/output error or -bash: Read-only file system
• Dropzone.js: Drag’n’Drop File Uploads with Image Previews

Updated Posts

• Lost connection during Debian apt-get upgrade
• Bootstrap 3 Navbar with Logo Image
• Redis HMGET, HGETALL, HSET, HGET Benchmark
• PHP GetHostByName() Slow? Make it Faster
• Use Timestamp with new DateTime() in PHP
• Calculate Elapsed Time Between Two Dates in PHP
• PHP Display Date Same as Server HTTP Headers Date
• PHP cURL Download Size Limit