dump mysql database schema

dump_mysql_db_schema.sh

#!/bin/sh

MYSQLDUMP=`which mysqldump`

DB="mysql"
HOST="127.0.0.1"
USER="root"
PASS="root"

# backup file settings
BACKUPDIR="${HOME}/backup/mysql"
mkdir -p $BACKUPDIR
DATE=`date "+%Y%-m%-d-%H%M"`
FILE="$BACKUPDIR/$DB-$DATE.sql"

OPTS="--verbose --force --quick --compress --comments --triggers --routines --dump-date --skip-add-drop-table --extended-insert --delayed-insert --order-by-primary"

# dump schema
$MYSQLDUMP --host=$HOST --user=$USER --password=$PASS --no-data $OPTS $DB > $FILE