Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- ### MySQL Server Login Info ###
- MUSER="root"
- MPASS="MYSQL-ROOT-PASSWORD"
- MHOST="localhost"
- MYSQL="$(which mysql)"
- MYSQLDUMP="$(which mysqldump)"
- BAK="/backup/mysql"
- GZIP="$(which gzip)"
- ### FTP SERVER Login info ###
- FTPU="FTP-SERVER-USER-NAME"
- FTPP="FTP-SERVER-PASSWORD"
- FTPS="FTP-SERVER-IP-ADDRESS"
- NOW=$(date +"%d-%m-%Y")
- [ ! -d "$BAK" ] && mkdir -p "$BAK"
- DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
- for db in $DBS
- do
- FILE=$BAK/$db.$NOW-$(date +"%T").gz
- $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
- done
- lftp -u $FTPU,$FTPP -e "mkdir /mysql/$NOW;cd /mysql/$NOW; mput /backup/mysql/*; quit" $FTPS
- ### Automatization:
- ### $ sudo crontab -e
- ### @midnight /home/you/mysql.backup.sh >/dev/null 2>&1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement