When we need to dump some particular tables instead of all of them, we could do the following command:
$ DBTODUMP=histquote
$ SQL=”SET group_concat_max_len = 10240;”
$ SQL=”${SQL} SELECT GROUP_CONCAT(table_name separator ‘ ‘)”
$ SQL=”${SQL} FROM information_schema.tables WHERE
$ table_schema=’${DBTODUMP}’”
$ SQL=”${SQL} AND table_name like ‘ind%%’”
$ TBLIST=`mysql -u username -p password -AN -e”${SQL}”`
$ mysqldump -u username -p password ${DBTODUMP} ${TBLIST} > ind_tables.sql
Run them in linux terminal.
