#!/bin/bash<br></br>
SKIPDB="mysql test"<br></br>
BACKUP_DIR="/backup/dir"<br></br>
DBS="$(mysql -Bse 'show databases')"<br></br>
for db in $DBS;do<br></br>
echo "Backing up Database:$db"<br></br>
mysqldump $db | /bin/gzip -9 > ${BACKUP_DIR}/${db}.gz<br></br>
echo "Backup complete for DB:$db"<br></br>
done```