Mysqlbackup gzip.sh
From Ye Ole Stash
- You need to create a "backup user" for mysql to use this. One way to do this can be found Here
#!/bin/bash email=YOUREMAIL backuppath=/path/to/your/sqlbackup/dir for i in `mysql -u dbbackupadmin -p'yourpass' -e "show databases" | awk '{print $1}' | sed '/Database/d'`; do mysqldump -u dbbackupadmin -p'yourpass' $i | /bin/gzip > "$backuppath/$i-$(date +%m-%d).gz" if [ "$?" -ne 0 ]; then echo 'MYSQL for $i Backup:FAILED with-'$? | mail -s MySQL\ Backup\ Issue $email fi done #clean up /usr/bin/find $backuppath -type f -mtime +10 -exec rm -f {} \; #To extract just gunzip $i
