How to mysqldump specific tables?

This solution is from stackexchange.com- http://dba.stackexchange.com/questions/9306/how-do-you-mysqldump-specific-tables

DBTODUMP=mydb
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 NOT IN (‘t1′,’t2′,’t3′)”
TBLIST=`mysql -u… -p… -AN -e”${SQL}”`
mysqldump -u… -p… ${DBTODUMP} ${TBLIST} > mydb_tables.sql

0