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

Support easy restore of partial backup

    XMLWordPrintable

Details

    Description

      This came up in an InnoDB Birds of a Feather session.

      mariabackup --export is internally executing FLUSH TABLES…EXPORT on the backed-up files to allow the files to be imported to another server instance. But it does not appear to generate a script file that could be conveniently executed by the user in order to import the tables.

      It would be nice to have a sequence of SQL statements and shell commands for importing the exported tables. Maybe we could generate several files:

      1. create.sql with CREATE OR REPLACE TABLE…;ALTER TABLE…DISCARD TABLESPACE statements (not needed starting with MDEV-26137 in MariaDB Server 11.2)
      2. move.sh or move.bat for moving the files to the data directory
      3. import.sql containing the ALTER TABLE…IMPORT TABLESPACE statements.

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              marko Marko Mäkelä
              Votes:
              13 Vote for this issue
              Watchers:
              20 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.