MySQL快速卸数导数据工具

一、单个卸数脚本示例

select
	`SerialNo`,
	`CustomerId`,
	`OccurDate`,
	`RuleId`,
	`ChangeContext` 
	 from info_change  into outfile 
'/home/mysqldata/mysql_dump/files/info_change.txt'
 character set utf8mb4 fields terminated by x'0f' enclosed by '\"' lines terminated by '\n';

二、数据文件加载示例

先删除、后导入文件

 delete from info_change;

 load data local infile '/home/mysqldata/mysql_dump/files/info_change.txt'

 into table auth_info_change

 fields terminated by x'0f' enclosed by '\"' lines terminated by '\n';

 select count(1) as info_change_count from info_change;

三、mysql控制台卸数执行命令

使用 local-infile参数，表示从文件导入

mysql -udb_admin -pdb@123 --socket=/home/mysqldata/mysql_3306/data/mysqld.sock --local-infile