mysqldump指定前缀表

生成指定前缀表名列表文件

mysql -u root -p -N information_schema -e "select table_name from tables where table_schema = 'databasename' and table_name like 'bak_%'" > tables.txt

然后备份该文件列表里的表名即可

mysqldump dbname `cat tables.txt` > dump_file.sql