Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- PASSWORD=
- HOST=
- USER=
- DATABASE=
- DB_FILE=dump.sql
- EXCLUDED_TABLES=(
- )
- 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 --routines ${DATABASE} > ${DB_FILE}
- echo "Dump content"
- mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} ${DATABASE} --no-create-info --skip-triggers ${IGNORED_TABLES_STRING} >> ${DB_FILE}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement