Advertisement
Guest User

Untitled

a guest
Apr 19th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. #!/bin/bash
  2. ### MySQL Server Login Info ###
  3. MUSER="root"
  4. MPASS="root_password"
  5. MHOST="localhost"
  6. MYSQL="$(which mysql)"
  7. MYSQLDUMP="$(which mysqldump)"
  8. BAK="/path/to/export"
  9.  
  10. # USE THIS CODE TO BACKUP ONLY ONE SPECIFIC DB
  11. DB="my_database"
  12. FILE=$BAK/$db_back.sql
  13. $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $DB > $FILE
  14.  
  15. # USE BELOW CODE TO BACKUP ALL DBS And GZIP them
  16. # GZIP="$(which gzip)"
  17.  
  18. ### FTP SERVER Login info ###
  19. # FTPU="FTP-SERVER-USER-NAME"
  20. # FTPP="FTP-SERVER-PASSWORD"
  21. # FTPS="FTP-SERVER-IP-ADDRESS"
  22. # NOW=$(date +"%d-%m-%Y")
  23.  
  24. ### See comments below ###
  25. ### [ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/* ###
  26. # [ ! -d "$BAK" ] && mkdir -p "$BAK"
  27. # DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
  28. # for db in $DBS
  29. # do
  30. # FILE=$BAK/$db.$NOW-$(date +"%T").gz
  31. # $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
  32. # done
  33. #
  34. # 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