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

[23 Jun 2014 17:49] Morgan Tocker
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);
[23 Jun 2014 18:38] MySQL Verification Team
looks like http://bugs.mysql.com/bug.php?id=65465
[23 Jun 2014 19:09] Morgan Tocker
Thanks Shane - I agree.  You can close as a duplicate.
[30 Jun 2014 10:52] MySQL Verification Team
Thank you for the bug report, duplicate of http://bugs.mysql.com/bug.php?id=65465