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

• Customer emails don't show up in Zendesk
• Get Windows 7, 8, 10 License Information
• Cheapest Alternatives to Mailchimp, Sendinblue, Sendgrid
• Convert InnoSetup EXE Installer to MSI
• Get Serial Number of CPU, RAM, Motherboard, HDD
• Get Number of Intel Processor Cores via Registry
• Zendesk Remove [Business Name] from Email Subject on Ticket Replies
• Best Text-to-Speech (TTS) Web Services with Human Voices

Updated Posts

• Exclude Packages from Apt-Get Upgrade on Debian Linux
• Should I reboot Debian server after apt-get upgrade?
• Download and Install OpenVPN Client on Windows 10
• How to List All Iptables NAT Rules
• How to List INPUT, FORWARD, OUTPUT Iptables Rules
• OpenVPN Iptables Rules
• Parse or Split FTP URL in Delphi XE using TIdURI
• Public FTP Server to Test Upload and Download