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.
Other Posts
- Bash if elif else statement example
- Bash calculate elapsed time in hours minutes seconds
- Bash rm not works using wildcards and variable
- Execute a Bash script from an URL (wget and run script)
- Self-Deleting Bash Script in Linux
- Get the source directory of a Bash script
- Delete files older than N days using Bash shell in Linux
- Find and delete all files without extension using Bash