Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MYSQL_DATA=mydb
- MYSQL_USER=root
- MYSQL_PASS=rootpassword
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- SQL="SET group_concat_max_len = 102400;"
- SQL="${SQL} SELECT GROUP_CONCAT(CONCAT('--ignore-table=',table_name) SEPARATOR ' ')"
- SQL="${SQL} FROM information_schema.tables WHERE table_schema='${MYSQL_DATA}'"
- SQL="${SQL} AND table_name LIKE 'foo_%'"
- EXCLUSION_LIST=`mysql ${MYSQL_CONN} -AN -e"${SQL}"`
- mysqldump ${MYSQL_CONN} ${MYSQL_DATA} ${EXCLUSION_LIST} > ${MYSQL_DATA}_tables.sql
- SQL="${SQL} AND table_name LIKE 'foo_%'"
- SQL="${SQL} AND table_name REGEXP '_BAK_2[0-9][0-9][0-9][0-9][0-9][0-9][0-9]"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement