[GTALUG] Testing Restore of mySQL Database
Alvin Starr
alvin at netvel.net
Fri Dec 23 15:44:05 EST 2016
Many years ago I worked for a company that had a tape backup system they
sold with their computers.
Due to a firmware screw up for fewmonths the backuptapes were written
blank and thenwhen they were verified they verified as good.
Fortunatelynone of the banks that were using the systems had a problem
in that few months.
In this case Schrödinger's backup was dead,alive and invisible.
Regular testing is important.
On 12/23/2016 03:36 PM, Mauro Souza wrote:
> If you don't test, you will have a Schrödinger's backup: both valid
> and invalid at the same time, until you try a restore.
>
> On Dec 23, 2016 6:20 PM, "Alvin Starr via talk" <talk at gtalug.org
> <mailto:talk at gtalug.org>> wrote:
>
> On 12/23/2016 02:59 PM, Stephen via talk wrote:
>> With the discussion about backups, I would like to raise a
>> question I have had for some time.
>>
>> Having backups does no good if you cannot restore them. Files are
>> rather easy to test.
>>
>> But how do you test restoring a database?
>>
>> I back it up with the usual tool. I have the docs to do the restore.
>>
>> But how to test to make sure that restoring works, without
>> clobbering the active database?
>>
>> Thank you
>>
> you can recover on a different machine or start a second instance
> of the database on different ports.
> This is the kind of place where virtualization or containerization
> comes in handy.
>
> Testing your backups is always a good idea.
>
> --
> Alvin Starr || voice:(905)513-7688 <tel:%28905%29%20513-7688>
> Netvel Inc. || Cell:(416)806-0133 <tel:%28416%29%20806-0133>
> alvin at netvel.net <mailto:alvin at netvel.net> ||
>
>
> ---
> Talk Mailing List
> talk at gtalug.org <mailto:talk at gtalug.org>
> https://gtalug.org/mailman/listinfo/talk
> <https://gtalug.org/mailman/listinfo/talk>
>
--
Alvin Starr || voice: (905)513-7688
Netvel Inc. || Cell: (416)806-0133
alvin at netvel.net ||
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/talk/attachments/20161223/79ced4f1/attachment.html>
More information about the talk
mailing list