Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # Create backup for all databases
- w="$(date +'%d_%m_%Y_%H_%M_%S')"
- filename="db_$now".gz
- backupfolder="/mnt/ftp/dbbackups/test"
- fullpathbackupfile="$backupfolder/$filename"
- logfile="$backupfolder/"backup_log_"$(date +'%Y_%m')".txt
- echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
- mysqldump --user=root --password=XXXXX --default-character-set=utf8 mydatabase | gzip > "$fullpathbackupfile"
- echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
- chown myuser "$fullpathbackupfile"
- chown myuser "$logfile"
- echo "file permission changed" >> "$logfile"
- find "$backupfolder" -name db_backup_* -mtime +8 -exec rm {} \;
- echo "old files deleted" >> "$logfile"
- echo "operation finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
- echo "*****************" >> "$logfile"
- exit 0
Add Comment
Please, Sign In to add comment