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.
Attachments
Issue Links
duplicates
MDEV-16029mysqldump: dump and restore historical data
Closed
relates to
MDEV-16355Add option for mysqldump to read data as of specific timestamp from system-versioned tables
The second part (back to a specified date) can be done as part of MDEV-16355. Please comment there if you would like to see such a feature.
Aleksey Midenkov
added a comment - The first part is done as MDEV-16029 .
The second part (back to a specified date) can be done as part of MDEV-16355 . Please comment there if you would like to see such a feature.
People
Unassigned
Robert Dyas
Votes:
0Vote for this issue
Watchers:
3Start 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.
{"report":{"fcp":973.2000000476837,"ttfb":247.90000009536743,"pageVisibility":"visible","entityId":68796,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"3c80c536-077b-4584-8b55-c5973d51cf3f","navigationType":0,"readyForUser":1044.4000000953674,"redirectCount":0,"resourceLoadedEnd":826.8000001907349,"resourceLoadedStart":255.80000019073486,"resourceTiming":[{"duration":108.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":255.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":255.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":364.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":109.60000014305115,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":365.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":195,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":256.10000014305115,"connectEnd":256.10000014305115,"connectStart":256.10000014305115,"domainLookupEnd":256.10000014305115,"domainLookupStart":256.10000014305115,"fetchStart":256.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":373.80000019073486,"responseEnd":451.10000014305115,"responseStart":386.60000014305115,"secureConnectionStart":256.10000014305115},{"duration":269.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":256.2000000476837,"connectEnd":256.2000000476837,"connectStart":256.2000000476837,"domainLookupEnd":256.2000000476837,"domainLookupStart":256.2000000476837,"fetchStart":256.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":374.60000014305115,"responseEnd":525.8000001907349,"responseStart":388.90000009536743,"secureConnectionStart":256.2000000476837},{"duration":136.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":256.30000019073486,"connectEnd":256.30000019073486,"connectStart":256.30000019073486,"domainLookupEnd":256.30000019073486,"domainLookupStart":256.30000019073486,"fetchStart":256.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":376.10000014305115,"responseEnd":392.40000009536743,"responseStart":391.60000014305115,"secureConnectionStart":256.30000019073486},{"duration":149.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":256.30000019073486,"connectEnd":256.30000019073486,"connectStart":256.30000019073486,"domainLookupEnd":256.30000019073486,"domainLookupStart":256.30000019073486,"fetchStart":256.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":377.5,"responseEnd":405.80000019073486,"responseStart":405.10000014305115,"secureConnectionStart":256.30000019073486},{"duration":146.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":256.5,"connectEnd":256.5,"connectStart":256.5,"domainLookupEnd":256.5,"domainLookupStart":256.5,"fetchStart":256.5,"redirectEnd":0,"redirectStart":0,"requestStart":378.60000014305115,"responseEnd":403.40000009536743,"responseStart":402.5,"secureConnectionStart":256.5},{"duration":121.70000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":256.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":256.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":378.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":148.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":256.60000014305115,"connectEnd":256.60000014305115,"connectStart":256.60000014305115,"domainLookupEnd":256.60000014305115,"domainLookupStart":256.60000014305115,"fetchStart":256.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":382,"responseEnd":404.90000009536743,"responseStart":404.10000014305115,"secureConnectionStart":256.60000014305115},{"duration":123,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":256.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":256.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":379.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":157.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":256.80000019073486,"connectEnd":256.80000019073486,"connectStart":256.80000019073486,"domainLookupEnd":256.80000019073486,"domainLookupStart":256.80000019073486,"fetchStart":256.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":383.2000000476837,"responseEnd":414.10000014305115,"responseStart":413.10000014305115,"secureConnectionStart":256.80000019073486},{"duration":561.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":264.60000014305115,"connectEnd":264.60000014305115,"connectStart":264.60000014305115,"domainLookupEnd":264.60000014305115,"domainLookupStart":264.60000014305115,"fetchStart":264.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":528.5,"responseEnd":826.2000000476837,"responseStart":819,"secureConnectionStart":264.60000014305115},{"duration":562.1000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":264.7000000476837,"connectEnd":264.7000000476837,"connectStart":264.7000000476837,"domainLookupEnd":264.7000000476837,"domainLookupStart":264.7000000476837,"fetchStart":264.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":528.7000000476837,"responseEnd":826.8000001907349,"responseStart":819.8000001907349,"secureConnectionStart":264.7000000476837},{"duration":268.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":674.9000000953674,"connectEnd":674.9000000953674,"connectStart":674.9000000953674,"domainLookupEnd":674.9000000953674,"domainLookupStart":674.9000000953674,"fetchStart":674.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":910.2000000476837,"responseEnd":943.3000001907349,"responseStart":942.4000000953674,"secureConnectionStart":674.9000000953674},{"duration":152.29999995231628,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":964.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":964.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1116.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":162.10000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":985.7000000476837,"connectEnd":985.7000000476837,"connectStart":985.7000000476837,"domainLookupEnd":985.7000000476837,"domainLookupStart":985.7000000476837,"fetchStart":985.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1117.3000001907349,"responseEnd":1147.8000001907349,"responseStart":1147,"secureConnectionStart":985.7000000476837}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":124,"responseStart":248,"responseEnd":264,"domLoading":252,"domInteractive":1098,"domContentLoadedEventStart":1098,"domContentLoadedEventEnd":1137,"domComplete":1555,"loadEventStart":1555,"loadEventEnd":1555,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1078},{"name":"bigPipe.sidebar-id.end","time":1078.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1079.9000000953674},{"name":"activityTabFullyLoaded","time":1158.8000001907349}],"measures":[],"correlationId":"45789b0abee678","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Major
The first part is done as
MDEV-16029.The second part (back to a specified date) can be done as part of
MDEV-16355. Please comment there if you would like to see such a feature.