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

• Detect VMWare Virtual Machine
• Detect Microsoft Virtual PC Virtual Machine
• Fix MariaDB 10.5 "Can't create test file" errors
• Use MariaDB and MySQL without Password (MySQL Backup)
• Check if a Trademark is already registered
• Make name server address permanent in /etc/resolv.conf
• InnoSetup error the servicemanager is not available
• InnoSetup disable DesktopIcon via command-line

Updated Posts

• Use cURL to check for SSL certificate issues:
• How to test Socks5 proxy with cURL
• How to use variables in a sed command
• Best Socks5 Servers for Linux Debian
• Error NO_PUBKEY in Google Cloud Debian Packages Update
• How to Run a Command with Time Limit in Bash Linux
• MySQL InnoDB log sequence number is in the future
• Download CSV Top 1 Million Websites by Popularity