1
2
3
4
5
6
7
8
9
10
11 | for db in $DBS
do
if [ "$db" != "it-sat-wiki-old" ] && [ $db != "phpmyadmin" ] && [ $db != "performance_schema" ] && [ $db != "#mysql50#lost+found" ] && [ $db != "information_schema" ]
then
FILE=$BAK/$db.$NOW-$(date +"%T").gz
echo "$FILE"
$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
echo "$FILE"
scp -v ${FILE} <REDACTED>@<REDACTED>:/srv/backups/MySQL/
fi
done
|