Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- ### MySQL Server Login Info ###
- MUSER="root"
- MPASS="root_password"
- MHOST="localhost"
- MYSQL="$(which mysql)"
- MYSQLDUMP="$(which mysqldump)"
- BAK="/path/to/export"
- # USE THIS CODE TO BACKUP ONLY ONE SPECIFIC DB
- DB="my_database"
- FILE=$BAK/$db_back.sql
- $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $DB > $FILE
- # USE BELOW CODE TO BACKUP ALL DBS And GZIP them
- # 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")
- ### See comments below ###
- ### [ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/* ###
- # [ ! -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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement