mysqldump structure and data in seperate files

mysql-dump-structure-data.sh

#!/bin/sh

MYSQLDUMP=`which mysqldump`

HOST=$1
DATABASE=$2
USER=$3
PASS=$4

DATE=`date -u +"%Y%m%d_%H%M%Z"`
FILE_STRUCTURE="${DATABASE}_${DATE}_structure.sql"
FILE_DATA="${DATABASE}_${DATE}_data.sql"
OUTPUTDIR=${5:-/tmp}
MYSQLDUMP=`which mysqldump`


# structure
echo "----> dumping structure...\n"
${MYSQLDUMP} -h${HOST} -u${USER} -p${PASS} ${DATABASE} --no-data --add-drop-table --comments --compress --create-options > ${OUTPUTDIR}/${FILE_STRUCTURE}
echo "----> dumping structure done. \n"

echo "----> dumpung data...\n"
${MYSQLDUMP} -h${HOST} -u${USER} -p${PASS} ${DATABASE} --complete-insert --skip-extended-insert --skip-create-options --no-create-info > ${OUTPUTDIR}/${FILE_DATA}
echo "----> dumping data done\n"