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
- Delphi 10 Berlin System.Hash MD5 SHA1 SHA2 Hash
- 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