[GTALUG] Testing Restore of mySQL Database

Mauro Souza thoriumbr at gmail.com
Fri Dec 23 15:36:21 EST 2016


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> 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 <(905)%20513-7688>
> Netvel Inc.                   ||   Cell:  (416)806-0133 <(416)%20806-0133>alvin at netvel.net              ||
>
>
> ---
> Talk Mailing List
> talk at gtalug.org
> https://gtalug.org/mailman/listinfo/talk
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/talk/attachments/20161223/be95872c/attachment.html>


More information about the talk mailing list