mysqldump 批量导出数据库表

 先查询需要导出的数据表，使用语句

SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = '数据库名' 
AND table_name LIKE 'mall%';
 

再批量导出查询到的表

mysqldump -u root -p test_yogasala mall_ad mall_address mall_admin mall_cart mall_category mall_except_area mall_except_area_detail mall_footprint mall_formid mall_freight_template mall_freight_template_detail mall_freight_template_group mall_goods mall_goods_gallery mall_goods_specification mall_keywords mall_notice mall_order mall_order_express mall_order_goods mall_product mall_region mall_search_history mall_settings mall_shipper mall_show_settings mall_specification > export_data.sql