reenadak

backup mysql databases with bash

Sep 25th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. # modify the following to suit your environment
  4.  
  5. dir_backup="/home/user1/mysql_backup"
  6. db_user=actual_username
  7. db_pass=actual_password
  8. db_host=localhost_or_actual-host
  9.  
  10. echo ""
  11. echo "mySQL_backup"
  12. echo "----------------------"
  13. echo "* Rotating backups..."
  14.  
  15. # Deleting oldest backup.
  16. rm -rf $dir_backup/04
  17.  
  18. mv $dir_backup/03 $dir_backup/04
  19. mv $dir_backup/02 $dir_backup/03
  20. mv $dir_backup/01 $dir_backup/02
  21.  
  22. mkdir $dir_backup/01
  23.  
  24. echo "* Creating new backup..."
  25. mysqldump --opt -u $db_user -p$db_pass -h $db_host --all-databases | bzip2 > $dir_backup/01/mysql-`date +%Y-%m-%d`.bz2
  26.  
  27. echo "----------------------"
  28. echo "Done"
  29. exit 0
Add Comment
Please, Sign In to add comment