Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
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?