Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- PASSWORD=XXXXXX
- HOST=XXXXXX
- USER=XXXXXX
- DATABASE=databasename
- DB_FILE=dump.sql
- EXCLUDED_TABLES=(
- table1
- table2
- table3
- table4
- tableN
- )
- IGNORED_TABLES_STRING=''
- for TABLE in "${EXCLUDED_TABLES[@]}"
- do :
- IGNORED_TABLES_STRING+=" --ignore-table=${DATABASE}.${TABLE}"
- done
- echo "Dump structure"
- mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} --single-transaction --no-data ${DATABASE} > ${DB_FILE}
- echo "Dump content"
- mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} ${DATABASE} --routines --triggers --no-create-info ${IGNORED_TABLES_STRING} >> ${DB_FILE}
- echo "Cleaning Up DEFINERs"
- sed -i -E 's/DEFINER=`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' ${DB_FILE}
- echo "Compressing Dump File"
- gzip ${DB_FILE}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement