mysqldump导出通配符表

  sre
mysqldump -uxx -pxx a $(mysql -uxx -pxx -Da -Bse "show tables from a where tables_in_a like 'tmp_%' or tables_in_a like 'space_%'") > a.sql
#其中tables_in_库名 是默认字段

LEAVE A COMMENT

Captcha Code