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 Display Date Same as Server HTTP Headers Date
• Google Cloud Load Balancer Firewall Rules
• Create Instance Template out of Disk Snapshot on Google Cloud
• Get User IP Address From Google Cloud Load Balancer
• Connect as Root using WinSCP on Google Cloud Compute Engine
• Become Root on Google Cloud Compute Engine VMs
• Connect to Google Cloud Compute Engine VM via PuTTY SSH
• DigitalOcean Slow, My Experience

Updated Posts

• PHP GetHostByAddr() Slow? Make it Faster
• PHP GetHostByName() Slow? Make it Faster
• How to Match Newline with Strpos() in PHP
• Use PHP Strpos() to Check if a String Starts with
• How to Run a Command with Time Limit in Bash Linux
• Unable to extract and upload PackageInfo.xml
• Stop Bad Bots from Crawling Your Website
• DEB.SURY.ORG Updated the Signing Key (March 2019)