mysql 导入导出 命令

导出

select * from dmsp_consume_stat into outfile '/tmp/dd2/dmsp_consume_stat' ;

导入

LOAD DATA INFILE '/tmp/dmsp_payment_details' INTO TABLE dmsp_payment_details;


  也可以 跳过 异常
  LOAD DATA INFILE '/tmp/pu_user_device' ignore INTO TABLE pu_user_device ;