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

• How to Disable Hibernation on Windows 10
• Disable Windows Defender on Windows 10 via Regedit
• Install Latest NVIDIA Drivers for Windows 10
• How to improve security of encrypted hard disks
• Get Server IP Address with Ifconfig and IP in Bash
• bash: ipconfig: command not found
• Check if a number is within a range in bash
• Linux Commands to Check HDD from Rescue Mode

Updated Posts

• Double Opt-in Email Newsletter Made Right (by Yoast)
• Let's Encrypt on Nginx and SSL Grade A+
• Free Email Ticketing Systems for Startups
• Delphi URLEncode like PHP
• Delphi Function to Parse JSON Unicode Chars
• Ask Users What Features They Need (Product Roadmap)
• Make Your Domain Emails Not Spoofeable
• Create Documentations Easily with GitBook