document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. #!/bin/bash
  2.  
  3. # modify the following to suit your environment
  4. export DB_BACKUP="/baks/mysql"
  5. export DB_USER="root"
  6. export DB_PASSWD="your-mysql-password-goes-here"
  7.  
  8. # title and version
  9. echo ""
  10. echo "Backup and rotate all mysql databases"
  11. echo "--------------------------"
  12.  
  13. rm -rf $DB_BACKUP/04
  14. mv $DB_BACKUP/03 $DB_BACKUP/04
  15. mv $DB_BACKUP/02 $DB_BACKUP/03
  16. mv $DB_BACKUP/01 $DB_BACKUP/02
  17. mkdir $DB_BACKUP/01
  18.  
  19. echo "* Creating backup..."
  20. mysqldump --user=$DB_USER --password=$DB_PASSWD --all-databases | bzip2 > $DB_BACKUP/01/mysql-`date +%Y-%m-%d`.bz2
  21. echo "----------------------"
  22. echo "Done"
  23. exit 0
');