用mysqldump导出数据库时，怎么将一个大表分成若干insert导出呀。Mysql Administrator 就是这样实现的

Question

导出结果如下（这样恢复效率好像很高）：
INSERT INTO `alarm` (`id`,`EquipAddr`,`SubnetID`,`AlmCode`,`BeginTime`,`EndTime`,`CardNo`,`Param0`,`Param1`,`Param2`,`Param3`,`PortType`,`UserName`,`Confirmed`,`Partner`,`AlmLevel`,`ConfirmTime`,`AreaID`,`AlarmType`,`AlarmID`,`VC4Index`) VALUES 
 (26823,'1643204943',53,136,'2007-12-13 18:26:02',NULL,2,9,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26824,'1643204943',53,136,'2007-12-13 18:26:03',NULL,2,10,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26825,'1643204943',53,136,'2007-12-13 18:26:03',NULL,2,11,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26826,'1643204943',53,136,'2007-12-13 18:26:04',NULL,2,12,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26827,'1643204943',53,136,'2007-12-13 18:26:04',NULL,2,13,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26828,'1643204943',53,136,'2007-12-13 18:26:04',NULL,2,14,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26829,'1643204943',53,136,'2007-12-13 18:26:05',NULL,2,15,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26830,'1643204943',53,136,'2007-12-13 18:26:05',NULL,2,16,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26831,'1643204943',53,136,'2007-12-13 18:26:05',NULL,2,17,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255);
INSERT INTO `alarm` (`id`,`EquipAddr`,`SubnetID`,`AlmCode`,`BeginTime`,`EndTime`,`CardNo`,`Param0`,`Param1`,`Param2`,`Param3`,`PortType`,`UserName`,`Confirmed`,`Partner`,`AlmLevel`,`ConfirmTime`,`AreaID`,`AlarmType`,`AlarmID`,`VC4Index`) VALUES 
 (26832,'1643204943',53,136,'2007-12-13 18:26:06',NULL,2,18,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26833,'1643204943',53,136,'2007-12-13 18:26:06',NULL,2,19,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26834,'1643204943',53,136,'2007-12-13 18:26:06',NULL,2,20,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26835,'1643204943',53,136,'2007-12-13 18:26:07',NULL,2,21,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26836,'1643204943',53,136,'2007-12-13 18:26:07',NULL,2,22,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26837,'1643204943',53,136,'2007-12-13 18:26:07',NULL,2,23,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26838,'1643204943',53,136,'2007-12-13 18:26:07',NULL,2,24,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26839,'1643204943',53,136,'2007-12-13 18:26:08',NULL,2,25,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255),
 (26840,'1643204943',53,136,'2007-12-13 18:26:08',NULL,2,26,255,255,255,1,NULL,0,0,4,NULL,4,8,12,255);

Answer 1

这个就是MYSQL的批量插入语句。

Answer 2

那导出时如何生成这种批量插入呢？
一个大表，批量插入，每次插入一部分和一下子全批量插入的效率差别有多大？
是不是非常大，耗时差数量级呀
我现在用mysqldump生成的文件就是一下插入所有的，耗时不能忍受，8M的文件要2个小时才能恢复。
大家是不是这样呀
我的备份语句（只备份数据，不创建表）：
mysqldump -u root -proot --no-create-db --no-create-info --add-locks --quick --extended-insert -c --lock-tables --set-charset --disable-keys --databases *** > ***.sql
谢谢啦

Answer 3

mysqldump 默认生成批量语句。
详细见我博客。