Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [BASH SCRIPTING] Automatic backup database on MySQL Server
- #!/bin/bash
- # Database Credentials
- user="yourdatabaseusername"
- password="yourdatabasepassword"
- host="yourdatabasehost"
- db_name="yourdatabasename"
- # Option
- backup_path="/home/backups/databases/"
- date=$(date +"%d-%b-%Y")
- # File permission
- umask 177
- # Dump database
- mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql
- # Delete backup database more than 7 days
- find $backup_path/* -mtime +7 -exec rm {} \;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement