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

Can't import Temporal HIstorical data from backup

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • N/A
    • None

    Description

      I can't seem to get my historical (temporal) data to import into a new instance of my database.

      I've use `mariadb-dump` with the `-H` command to dump the history.
      I see the columns `row_start` and `row_end` in the generated insert statements but not in the table create statements.

      However, two things happen:

      1. If I use the script as is an import the data the `row_start` and `row_end` times are the CURRENT date/time of the import and not what was in the file.

      2. If I remove the `WITH SYSTEM_VERSIONING` in the generated script figuring we can't manually insert those values and I'll re-enable versioning after the import, when I try again the import fails because it can't find columns `row_start` and `row_end`

      How are we supposed to backup and restore temporal tables?

      Attachments

        Activity

          People

            Unassigned Unassigned
            tmulle Tim
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.