[MDEV-25152] "mysqldump --extended-insert" could insert linebreaks between rows Created: 2021-03-15 Updated: 2021-10-04 Resolved: 2021-10-01 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Scripts & Clients |
| Fix Version/s: | 10.7.0 |
| Type: | Task | Priority: | Minor |
| Reporter: | Steve Mokris | Assignee: | Daniel Black |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | beginner-friendly | ||
| 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:
|
| Comments |
| Comment by Zhao Junwang [ 2021-05-14 ] |
|
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 |
| Comment by Rui Alves [ 2021-06-22 ] |
|
I have created the pull request #1865 for this issue |
| Comment by Rui Alves [ 2021-08-08 ] |
|
The pull request #1865 was updated with the necessary fixes |
| Comment by Daniel Black [ 2021-10-01 ] |
|
Thanks for the contribution rmfalves. |