# Optional variables for a backup script
MYSQL_USER="root"
MYSQL_PASS=""
DB_NAME=""
BACKUP_DIR="backup"

test -d "$BACKUP_DIR" || mkdir -p "$BACKUP_DIR"
# Get the database list, exclude information_schema
for table in $(mysql -B -s -u $MYSQL_USER --password=$MYSQL_PASS $DB_NAME -e 'show tables')
do
  echo $table
  # dump each database in a separate file
  mysqldump -u $MYSQL_USER --password=$MYSQL_PASS "$DB_NAME" "$table" 2> /dev/null | gzip > "$BACKUP_DIR/$table.sql.gz"
done