1、模糊查詢表象
root@serv: ~$ mysqldump dbname $(mysql -D YOURDBNAME -Bse "SHOW TABLES LIKE 'table_pattern_%'") > /tmp/database-dump.sql
2、指定表列表導(dǎo)出
導(dǎo)出表名稱：
mysql -N information_schema -e "select table_name from tables where table_schema = 'dbname' and table_name like 'sys_%'" > tables.txt 導(dǎo)出表：
mysqldump dbname `cat tables.txt` >> dump_file.sql
批量刪除表：
mysql -NB information_schema -e "select table_name from tables where table_name like 'sys_%'" | xargs -I"{}" mysql dbname -e "DROP TABLE {}"