howtos:mysql_backup_script
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | howtos:mysql_backup_script [02/12/2018 21:34] (current) – created - external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | < | ||
+ | #!/bin/sh | ||
+ | # System + MySQL backup script | ||
+ | # Copyright (c) 2008 Marchost | ||
+ | # This script is licensed under GNU GPL version 2.0 or above | ||
+ | # --------------------------------------------------------------------- | ||
+ | ######################### | ||
+ | ######TO BE MODIFIED##### | ||
+ | |||
+ | ### System Setup ### | ||
+ | BACKUP=YOUR_LOCAL_BACKUP_DIR | ||
+ | |||
+ | ### MySQL Setup ### | ||
+ | MUSER=" | ||
+ | MPASS=" | ||
+ | MHOST=" | ||
+ | |||
+ | ### FTP server Setup ### | ||
+ | FTPD=" | ||
+ | FTPU=" | ||
+ | FTPP=" | ||
+ | FTPS=" | ||
+ | |||
+ | ######DO NOT MAKE MODIFICATION BELOW##### | ||
+ | ######################################### | ||
+ | |||
+ | ### Binaries ### | ||
+ | TAR=" | ||
+ | GZIP=" | ||
+ | FTP=" | ||
+ | MYSQL=" | ||
+ | MYSQLDUMP=" | ||
+ | |||
+ | ### Today + hour in 24h format ### | ||
+ | NOW=$(date +" | ||
+ | |||
+ | ### Create hourly dir ### | ||
+ | |||
+ | mkdir $BACKUP/ | ||
+ | |||
+ | ### Get all databases name ### | ||
+ | DBS=" | ||
+ | for db in $DBS | ||
+ | do | ||
+ | |||
+ | ### Create dir for each databases, backup tables in individual files ### | ||
+ | mkdir $BACKUP/ | ||
+ | |||
+ | for i in `echo "show tables" | ||
+ | do | ||
+ | FILE=$BACKUP/ | ||
+ | echo $i; $MYSQLDUMP --add-drop-table --allow-keywords -q -c -u $MUSER -h $MHOST -p$MPASS $db $i | $GZIP -9 > $FILE | ||
+ | done | ||
+ | done | ||
+ | |||
+ | ### Compress all tables in one nice file to upload ### | ||
+ | |||
+ | ARCHIVE=$BACKUP/ | ||
+ | ARCHIVED=$BACKUP/ | ||
+ | |||
+ | $TAR -cvf $ARCHIVE $ARCHIVED | ||
+ | |||
+ | ### Dump backup using FTP ### | ||
+ | cd $BACKUP | ||
+ | DUMPFILE=$NOW.tar.gz | ||
+ | $FTP -n $FTPS << | ||
+ | quote USER $FTPU | ||
+ | quote PASS $FTPP | ||
+ | cd $FTPD | ||
+ | mput $DUMPFILE | ||
+ | quit | ||
+ | END_SCRIPT | ||
+ | |||
+ | ### Delete the backup dir and keep archive ### | ||
+ | |||
+ | rm -rf $ARCHIVED | ||
+ | |||
+ | </ |
howtos/mysql_backup_script.txt · Last modified: 02/12/2018 21:34 by 127.0.0.1