Some bash functions to dump and load a mysql database

dbdump.sh

# Dump a mysql database to a gzipped sql file
dbdump() {
  # (adjust defaults as required)
  GZ_FILE=$1; [ ! -n "$GZ_FILE" ] && GZ_FILE="$HOME/.dbdump.gz"
  DB_NAME=$2; [ ! -n "$DB_NAME" ] && DB_NAME='fms'
  echo -n "Dumping database $DB_NAME to $GZ_FILE..."
  # Add --extended-insert=FALSE to mysql command for more readable but MUCH slower sql
  mysqldump -u root $DB_NAME | gzip - > "$GZ_FILE"
  echo ' Done'
}

# Load a mysql database from a gzipped sql file
dbload() {
  # (adjust defaults as required)
  GZ_FILE=$1; [ ! -n "$GZ_FILE" ] && GZ_FILE="$HOME/.dbdump.gz"
  DB_NAME=$2; [ ! -n "$DB_NAME" ] && DB_NAME='fms'
  echo -n "Loading database $DB_NAME from $GZ_FILE..."
  echo "DROP DATABASE $DB_NAME; CREATE DATABASE $DB_NAME;" | mysql -u root
  zcat $GZ_FILE | mysql -u root -D $DB_NAME
  echo ' Done'
}