Created
October 21, 2017 10:07
-
-
Save marinsagovac/e7bda3c15ef089930f9aefa588883e89 to your computer and use it in GitHub Desktop.
Backup MySQL script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# Script will output dumps for all databases using seperate files | |
# Derived from this post: http://www.cyberciti.biz/faq/ubuntu-linux-mysql-nas-ftp-backup-script/ | |
USER="root" | |
PASSWORD="SnM1073k" | |
HOST="localhost" | |
MYSQL="$(which mysql)" | |
MYSQLDUMP="$(which mysqldump)" | |
OUTPUT_DIR="/backups/files" | |
# Parse options | |
while getopts ":u:p:h:o:" opt; do | |
case $opt in | |
u) | |
USER=$OPTARG | |
;; | |
p) | |
PASSWORD=$OPTARG | |
;; | |
h) | |
HOST=$OPTARG | |
;; | |
o) | |
OUTPUT_DIR=$OPTARG | |
;; | |
\?) | |
echo "Invalid option: -$OPTARG" >&2 | |
exit 1 | |
;; | |
:) | |
echo "Option -$OPTARG requires an argument." >&2 | |
exit 1 | |
;; | |
esac | |
done | |
VALIDATION_ERROR=false | |
if [ -z "$USER" ]; then | |
echo "User has not been specified" >&2 | |
VALIDATION_ERROR=true | |
fi | |
if [ -z "$PASSWORD" ]; then | |
echo "Password has not been specified" >&2 | |
VALIDATION_ERROR=true | |
fi | |
if [ -z "$OUTPUT_DIR" ]; then | |
echo "Output dir has not been specified" >&2 | |
VALIDATION_ERROR=true | |
fi | |
if $VALIDATION_ERROR ; then | |
exit 1 | |
fi | |
dd=`date +%Y%m%d` | |
DBS="$($MYSQL -u $USER -h $HOST -p$PASSWORD -Bse 'show databases')" | |
for db in $DBS | |
do | |
if [ $db != "information_schema" ]; then | |
FILE=$OUTPUT_DIR/$db$dd.sql | |
$MYSQLDUMP -u $USER -h $HOST -p$PASSWORD --skip-lock-tables $db > $FILE | |
fi | |
done | |
# Delete all backups older than 7 days | |
find $OUTPUT_DIR -mtime +7 -exec rm -f {} \; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment