Advertisement
mqnoy

[MYSQL] Automatic backup database on MySQL Server

Jun 15th, 2016
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.51 KB | None | 0 0
  1. [BASH SCRIPTING] Automatic backup database on MySQL Server
  2. #!/bin/bash
  3. # Database Credentials
  4. user="yourdatabaseusername"
  5. password="yourdatabasepassword"
  6. host="yourdatabasehost"
  7. db_name="yourdatabasename"
  8. # Option
  9. backup_path="/home/backups/databases/"
  10. date=$(date +"%d-%b-%Y")
  11. # File permission
  12. umask 177
  13. # Dump database
  14. mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql
  15. # Delete backup database more than 7 days
  16. find $backup_path/* -mtime +7 -exec rm {} \;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement