[GTALUG] Testing Restore of mySQL Database
Alvin Starr
alvin at netvel.net
Fri Dec 23 15:20:42 EST 2016
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
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/6e47cd71/attachment.html>
More information about the talk
mailing list