[MDEV-16798] need mysqldump option to include SYSTEM VERSIONING historical records in backups Created: 2018-07-21 Updated: 2018-07-27 Resolved: 2018-07-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Versioned Tables |
| Fix Version/s: | 10.3.9 |
| Type: | Task | Priority: | Major |
| Reporter: | Robert Dyas | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
The MariaDB documentation states: "mysqldump does not read historical rows from versioned tables, and so historical data will not be backed up." I would like to request that an option be added to mysqldump to include all system versioning history, or possibly include all system versioning history back to a specified date. If companies are going to use this for their audit trail, that audit trail needs to be backed up (and easily restored). Thank you. |
| Comments |
| Comment by Aleksey Midenkov [ 2018-07-27 ] |
|
The first part is done as The second part (back to a specified date) can be done as part of |