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

mariadb-dump: Ability to backup selected partitions only

Details

    Description

      This JIRA task tracks PR 3891

      Description from PR

      This code adds ability to backup selected partition(s) by mariadb-dump by using --partition-separator=@ and then specifying partition name in table's name, eg. mytable1@p0,p1. There should be no side effects, support for selecting partition(s) is disabled by default.

      ./mariadb-dump -umyuser -pmypass -h127.0.0.1 mydatabase _test1@p0,p1 _test2@p0 --partition-separator=@
      

      TODO

      This approach needs to be validated as the correct use experience, then the implementation will be reviewed.

      Attachments

        Activity

          cvicentiu Vicențiu Ciorbaru created issue -
          cvicentiu Vicențiu Ciorbaru made changes -
          Field Original Value New Value
          Description This JIRA task tracks [PR 3891|https://github.com/MariaDB/server/pull/3891]

          h2. Description
          This code adds ability to backup selected partition(s) by mariadb-dump by using --partition-separator=@ and then specifying partition name in table's name, eg. mytable1@p0,p1. There should be no side effects, support for selecting partition(s) is disabled by default.
          {code}
          ./mariadb-dump -umyuser -pmypass -h127.0.0.1 mydatabase _test1@p0,p1 _test2@p0 --partition-separator=@
          {code}

          This JIRA task tracks [PR 3891|https://github.com/MariaDB/server/pull/3891]

          h2. Description
          This code adds ability to backup selected partition(s) by {{mariadb-dump}} by using {{--partition-separator=@}} and then specifying partition name in table's name, eg. {{mytable1@p0,p1}}. There should be no side effects, support for selecting partition(s) is disabled by default.
          {code}
          ./mariadb-dump -umyuser -pmypass -h127.0.0.1 mydatabase _test1@p0,p1 _test2@p0 --partition-separator=@
          {code}

          cvicentiu Vicențiu Ciorbaru made changes -
          Description This JIRA task tracks [PR 3891|https://github.com/MariaDB/server/pull/3891]

          h2. Description
          This code adds ability to backup selected partition(s) by {{mariadb-dump}} by using {{--partition-separator=@}} and then specifying partition name in table's name, eg. {{mytable1@p0,p1}}. There should be no side effects, support for selecting partition(s) is disabled by default.
          {code}
          ./mariadb-dump -umyuser -pmypass -h127.0.0.1 mydatabase _test1@p0,p1 _test2@p0 --partition-separator=@
          {code}

          This JIRA task tracks [PR 3891|https://github.com/MariaDB/server/pull/3891]

          h2. Description from PR
          This code adds ability to backup selected partition(s) by {{mariadb-dump}} by using {{--partition-separator=@}} and then specifying partition name in table's name, eg. {{mytable1@p0,p1}}. There should be no side effects, support for selecting partition(s) is disabled by default.
          {code}
          ./mariadb-dump -umyuser -pmypass -h127.0.0.1 mydatabase _test1@p0,p1 _test2@p0 --partition-separator=@
          {code}

          h2. TODO
          This approach needs to be validated as the correct use experience, then the implementation will be reviewed.
          cvicentiu Vicențiu Ciorbaru made changes -
          Component/s Scripts & Clients [ 11002 ]

          People

            Unassigned Unassigned
            cvicentiu Vicențiu Ciorbaru
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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