mysqldump 테이블 선택적으로 덤프 뜨기

mysql databasename -u [root] -p[password] -e 'show tables like "table_name_like_%"' | grep -v Tables_in

| xargs mysqldump [databasename] -u [root] -p[password] > [target_file]


출처 : http://kristiannissen.wordpress.com/2009/03/13/mysqldump-selected-tables/