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
- PHP Notice: Undefined offset: 1 (Array)
- How to Sleep/Wait/Pause on a NodeJs Function
- How to Run a NodeJs Script
- How to Install a Module/Package/Library in NodeJs
- NodeJs Request.Get Example with Error Handling
- NodeJs HTTPS.Get Example with Error Handling
- How to Find PHP.ini Location
- How to Enable Display of Errors in PHP
Updated Posts
- Detect a failing hard-disk on a Linux server
- Certbot.errors.CertStorageError: expected to be a symlink
- Example hard-disk error logs on a Linux server
- Certbot renew error: Account at does not exist.
- Suspicious online shops from helpandserving@gmail.com
- Nginx Rewrite Rule to Add Slash to The End of Any URL
- Compress Word, Excel and PowerPoint Office Documents
- Download OpenVPN 2.4.7 and TAP-Windows