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

• Bash Get the size of a file
• Crontab requires escaping any % signs
• Bash Check folder size Linux
• Bash remove the first line of a large file
• ERROR 1114 (HY000): The table 'site' is fullage done
• Get Linux Server Unique Machine ID
• Linux make files accessible only by root
• Bash Autologin with MySQL MariaDB server

Updated Posts

• Backup MySQL datadir without Mysqldump
• Import MySQL Database from CommandLine
• Delphi 10 Berlin System.Hash MD5 SHA1 SHA2 Hash
• Standard ISO paper sizes, DPI and images size
• Download Google Chrome Full Standalone Offline Installer
• PHP cURL curl_getinfo() Output
• PHP cURL Get Redirect URL as Variable
• Upload a File via POST with cURL and PHP 7