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
      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

              Assignee:
              vlad.lesin Vladislav Lesin
              Reporter:
              marko Marko Mäkelä
              Votes:
              5 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated: