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

• NodeJs Request.Get Example with Error Handling
• NodeJs HTTPS.Get Example with Error Handling
• How to Find PHP.ini Location
• How to Enable Display of Errors in PHP
• Go One Directory Level Up/Back with Dirname() in PHP
• Save a String to File in Python
• Create a File Name with Current Date & Time in Python
• Get Current Script Path in Python

Updated Posts

• Compress Word, Excel and PowerPoint Office Documents
• Download OpenVPN 2.4.7 and TAP-Windows
• api-ms-win-crt-runtime-l1-1-0.dll is missing
• jQuery Get File Extension Before Uploading File
• Estimate Number of Visitors and Pageviews of any Website
• How to Configure OVH Email POP3 with Thunderbird
• Simple jQuery File Upload SimpleUpload.js
• Repeat AJAX GET Until a Specific Response is Met in jQuery