Unanswered: If you had to restore a database 25 years from now, what files would you include?
I've taken over some mysql dba tasks. I have a SQL Server background. Mysql is pretty new to me. We're running this on redhat. The current set up is a nightly cold backup that includes ibdata files, .err files, .frm, .MYD/MYI files.
There is a particular request to retain data for 25 years. I'm not 100% sure what files the previous dba was sending for this 25 year archive. Would some form of log suffice? I do believe this can occur on a monthly basis. Should I tar and zip the cold backup and use that? The last question seems like the safest. Perhaps the cnf files too?