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