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

• 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