mysqldump

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

Comments
Write a Comment