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

• View All Symlinks in a Directory Tree on Linux
• /etc/init.d/redis-server on Debian 9.5 Stretch
• View Last Time a File was Opened on Debian
• Fix PHP7.0-FPM Installation (Sury.org Packages)
• Server Certificate Verification failed CAfile (apt-get update)
• PDFYeah: Online Cloud-Based PDF Converter
• Create a SOCKS 5 Proxy on Top of a SSH Tunnel on Linux
• Estimate Number of Visitors and Pageviews of any Website

Updated Posts

• Htaccess file for WordPress websites
• How to Create Backups of MySQL via PHP
• Transfer files from a VPS to a FTP web hosting server
• 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