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

• Route OpenVPN Connections Through Floating IP
• How to Configure a Floating IP in a VPS (Hetzner)
• Set OpenVPN to Listed on a Specific IP Address
• Bash Trim Leading and Trailing Whitespace from a String
• Bash Get Name of Ethernet Network Interface
• VPN Providers with Dedicated Static IP Address
• OpenVPN Iptables Rules
• WireGuard VPN Iptables Rules

Updated Posts

• AMD Chipsets & Graphics Card Drivers for Windows 7, 8, 10
• AMD Radeon 7400 Drivers for Windows 10
• How to pass custom command-line parameters in InnoSetup
• Add Desktop shortcut for all Windows PC users
• Programmatically create desktop icon with InnoSetup
• GeneratePress - a Lightweight WordPress Theme 2021
• InnoSetup disable DesktopIcon via command-line
• Use cURL to authenticate with JWT Bearer tokens