Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # modify the following to suit your environment
- export DB_BACKUP="/baks/mysql"
- export DB_USER="root"
- export DB_PASSWD="your-mysql-password-goes-here"
- # title and version
- echo ""
- echo "Backup and rotate all mysql databases"
- echo "--------------------------"
- rm -rf $DB_BACKUP/04
- mv $DB_BACKUP/03 $DB_BACKUP/04
- mv $DB_BACKUP/02 $DB_BACKUP/03
- mv $DB_BACKUP/01 $DB_BACKUP/02
- mkdir $DB_BACKUP/01
- echo "* Creating backup..."
- mysqldump --user=$DB_USER --password=$DB_PASSWD --all-databases | bzip2 > $DB_BACKUP/01/mysql-`date +%Y-%m-%d`.bz2
- echo "----------------------"
- echo "Done"
- exit 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement