MySQL Bugs: #73083: mysqldump extended inserts should have new line character between each insert

Bug #73083	mysqldump extended inserts should have new line character between each insert
Submitted:	23 Jun 2014 17:49	Modified:	30 Jun 2014 10:52
Reporter:	Morgan Tocker	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: mysqldump Command-line Client	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Via: http://blog.lavoie.sl/2014/06/split-mysqldump-extended-inserts.html

And also:
http://stackoverflow.com/questions/1293529/how-to-deal-with-enormous-line-lengths-created-...
http://serverfault.com/questions/142588/mysql-dump-output-each-table-row-on-a-new-line-whi...

Extended inserts are hard to use grep and diff, since these tools are line oriented.  While it is possible to disable extended inserts, this may not be desirable due to decreased import performance / a larger dump file.

As a feature request, the format of mysqldump could be changed to insert a new-line character after each extended-insert row.  In most cases this will be a trivial increase in dump size.

How to repeat:
N/A

Suggested fix:
Change:
INSERT INTO mytable (id) VALUES (1),(2);

To be:
INSERT INTO mytable (id) VALUES
(1),
(2);

looks like http://bugs.mysql.com/bug.php?id=65465

Thanks Shane - I agree.  You can close as a duplicate.

Thank you for the bug report, duplicate of http://bugs.mysql.com/bug.php?id=65465