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

Support easy restore of partial backup

    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:
                8 Start watching this issue

                Dates

                • Created:
                  Updated: