Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- PASSWORD=123456
- HOST=localhost
- USER=root
- DATABASE=basename
- DB_FILE=dump-base.sql
- EXCLUDED_TABLES=(
- table1
- table2
- )
- 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} --no-create-info ${IGNORED_TABLES_STRING} >> ${DB_FILE}
Add Comment
Please, Sign In to add comment