By default, –extended-insert, -e is enabled when using mysqldump to create backups of MySQL databases. As seen in the example below, the dump file is prepared using multiple-row syntax, and each INSERT statement has several VALUES lists.
INSERT INTO `TestTable` VALUES (1,’value1′),(2,’value2′),(3,’value3′);
When the file is reloaded, it reduces the size of the dump file and speeds up insertion. You can avoid the extended insertions, though, if you don’t want to use such large insert statements or if you’re getting issues related to insufficient net-buffer-length.
mysqldump –opt –skip-extended-insert
Or you can use –
mysqldump –opt –extended-insert=FALSE
Now in your backup / dump file, you’ll have the insert statements as shown below.
INSERT INTO `TestTable` VALUES (1,’value1′);
INSERT INTO `TestTable` VALUES (2,’value2′);
INSERT INTO `TestTable` VALUES (3,’value3′);
Hope you find this article helpful.
Big Data & SQL 