:: How to dump a few tables in mysql

mysql databasename -u [root] -p[password] -e 'show tables like "table_name_%"' | grep -v Tables_in | xargs mysqldump [databasename] -u [root] -p[password] > [target_file]

 
:: Link
+ Google
+ StactExchange