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="/backups/mysql"
- export DB_USER="debian-sys-maint"
- export DB_PASSWD="password"
- # 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
Add Comment
Please, Sign In to add comment