mysqldump skip content from some tables (for GDRP)

export_db.sh

#!/bin/bash

HOST_NAME=XXXX
USER=XXXX
PASSWORD=XXXX
DATABASE_NAME=XXXX
DB_FILE=export.sql
EXCLUDED_TABLES=(
  table1
  table2
  table3
  table4
)

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

echo "Dump structure"
mysqldump --host=${HOST_NAME} --user=${USER} --password=${PASSWORD} --single-transaction --no-data --routines ${DATABASE_NAME} > ${DB_FILE}

echo "Dump content"
mysqldump --host=${HOST_NAME} --user=${USER} --password=${PASSWORD} ${DATABASE_NAME} --no-create-info --skip-triggers ${IGNORED_TABLES_STRING} >> ${DB_FILE}