This scripts generate a mysqldump commands to backup a MySQL database into two separate files. One for tables creation only and other for for data insertion;

mysql-backup.sh

#!/bin/bash
discendingTime(){
    date '+%Y.%m.%d.%H.%M.%S'
}
TIME_NOW=$(discendingTime)
HOST=$1
PORT=$2
USER=$3
DATABASE=$4
DB_FILE=$5-${DATABASE}-${TIME_NOW}
EXCLUDED_TABLES=(
)

IGNORED_TABLES_STRING=''
for TABLE in "${EXCLUDED_TABLES[@]}"
do :
    IGNORED_TABLES_STRING+=" --ignore-table=${DATABASE}.${TABLE}"
done

echo "# Dump structure"
echo "mysqldump --host=${HOST} --port=${PORT} --user=${USER} -p --single-transaction --no-data ${DATABASE} > ${DB_FILE}-DDL.sql"

echo "# Dump content"
echo "mysqldump --complete-insert --host=${HOST} --port=${PORT} --user=${USER} -p ${DATABASE} --no-create-info ${IGNORED_TABLES_STRING} > ${DB_FILE}-DATA.sql"