Posted on May 20, 2017 at 6:44 pm

The fastest way to backup MySQL datadir is:

1) Stop the MySQL service

service mysql stop

2) Copy /var/lib/mysql to another location, i.e:

cp -R /var/lib/mysql /root/mysqldatadir

3) Start the MySQL service

service mysql start

4) Compress the new MySQL datadir with tar:

tar czf /root/mysqldatadir.tar.gz /root/mysqldatadir

5) Now copy the compressed file in the backup server.

Read how to restore MySQL datadir on a new server.

Updated on September 20, 2017 at 5:06 pm

Other Posts

• PHP Generate Secure Random Passwords
• Google Cloud SQL and Public IP Address Security
• How to use Highlight.js to highlight code
• Nginx HTTP to HTTPS and non-www to www behind Google Load Balancer
• Quota 'IN_USE_ADDRESSES' exceeded. Limit: 8.0 in region
• Only allow Google Load Balancer traffic (Firewall Rules)
• Lost connection during Debian apt-get upgrade
• Bootstrap 3 Navbar with Logo Image

Updated Posts

• PHP StrToTime() Returns Incorrect Timestamp '-1 MONTH'
• PHP Correctly Get Last 12 Months (Month per Month)
• Nginx Redirect From a Website to Another Website
• PHP Multi-cURL to Run Parallel cURL Requests (Example)
• Let's Encrypt on Nginx and SSL Grade A+
• Vertically align Facebook and Twitter share buttons
• Download Windows 10 ISO without Media Creation Tool
• DEB.SURY.ORG Updated the Signing Key (March 2019)