#!/bin/bash
USER="root"
PASSWORD="dxcc48meA5zKtrAY"
OUTPUT="/home/zague/dbbackup"
# rm -f $OUTPUT"/*gz" > /dev/null 2>&1
# rm -f $OUTPUT"/*gz"
find $OUTPUT"/" -type f -name '*.gz' -mtime +14 -exec rm {} ;
databases=`mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
for db in $databases; do
if [[ "$db" != "mysql" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "information_schema" ]] && [[ "$db" != _* ]] ; then
echo "Dumping database: $db"
rm -f $OUTPUT/`date +%Y%m%d`.$db.sql
rm -f $OUTPUT/`date +%Y%m%d`.$db.sql.gz
mysqldump --force --opt --routines --add-drop-table --events --user=$USER --password=$PASSWORD --databases $db > $OUTPUT/`date +%Y%m%d`.$db.sql
gzip $OUTPUT/`date +%Y%m%d`.$db.sql
echo "GZip created: "$OUTPUT/`date +%Y%m%d`.$db.sql.gz
echo ""
fi
done
echo "Done!!!"