Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # Database credentials
- user="root"
- password="xxx2015"
- host="127.0.0.1"
- db_name="historico"
- backup_path="/backups/mensual"
- date=$(date +"%d-%b-%Y")
- #permisos por defecto
- umask 177
- mysqldump --user=$user --password=$password --routines --host=$host $db_name > $backup_path/$db_name-$date.sql
- bzip2 $backup_path/$db_name-$date.sql
- chmod 655 $backup_path/$db_name-$date.sql.bz2
- rm $backup_path/$db_name-$date.sql
- #borro backups de mas de 35 dias
- find $backup_path/* -mtime +35 -exec rm {} \;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement