# 导出带where条件
mysqldump --single-transaction --default-character-set=latin1 -h*.*.*.* -P6000 -udaiyuanpei_r -p****** bfb_db_14 t_trans_query_14_6 --where=" F_seller_user_id=1000000000019146 and F_seller_sub_account_type=1 and F_buyer_user_id like '%146'" > /home/work/t_trans_query_14_6.sql
# 导出
mysqldump --single-transaction --default-character-set=latin1 -h*.*.*.* -P6012 -udaiyuanpei_r -p****** bfb_db_finance t_scenarios > /home/work/t_scenarios.sql
# 导入
mysql -udaiyuanpei_r -p****** -h*.*.*.* -P6666
use bfb_db_finance;
source ~/t_scenarios.sql