Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
Description
Currently, mysqldump --extended-insert outputs all rows on a single line, which makes it difficult to use with various Unix command-line utilities such as grep and diff. If mysqldump could emit a linebreak between each row, that would make it easier to work with, without significantly affecting dump or restore performance, or affecting compatibility.
See also:
As Rick James mentioned in [1], this can be work around by adding `--net-buffer-length=4096`
I checked mysql-server source code a little bit, they do not insert linebreak either ;(
[1]: https://forums.mysql.com/read.php?28,420002,426160#msg-426160