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

ALTER TABLE IMPORT TABLESPACE does not allow import into another schema

    XMLWordPrintable

Details

    Description

      mariabdb-backup --prepare --export marks all InnoDB tables for export.

      One problem is that one cannot import a exported table to a schema with another name than the original. This would be useful when one wants to import an old backup of a table to another schema to compare it the current table.

      The reason for this is that the *.cfg files includes the schema name and the table name
      and ALTER TABLE ... IMPORT TABLESPACE gives an error if the schema differs.

      The suggestion is to change the error to a warning and allow the import.
      This should be done in an early MariaDB version to allow restore tools to take advantage of this change with all active MariaDB versions.

      Attachments

        Activity

          People

            Unassigned Unassigned
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.