Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25152

"mysqldump --extended-insert" could insert linebreaks between rows

Details

    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:

      Attachments

        Activity

          zhjwpku Zhao Junwang added a comment -

          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

          zhjwpku Zhao Junwang added a comment - 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
          rmfalves Rui Alves added a comment -

          I have created the pull request #1865 for this issue

          rmfalves Rui Alves added a comment - I have created the pull request #1865 for this issue
          rmfalves Rui Alves added a comment - - edited

          The pull request #1865 was updated with the necessary fixes

          rmfalves Rui Alves added a comment - - edited The pull request #1865 was updated with the necessary fixes
          danblack Daniel Black added a comment -

          Thanks for the contribution rmfalves.

          danblack Daniel Black added a comment - Thanks for the contribution rmfalves .

          People

            danblack Daniel Black
            smokris Steve Mokris
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.