Re: [GTALUG] Testing Restore of mySQL Database

2016-12-23 Thread Alvin Starr via talk
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

Re: [GTALUG] Testing Restore of mySQL Database

2016-12-23 Thread Mauro Souza via talk
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" wrote: > On 12/23/2016 02:59 PM, Stephen via talk wrote: > > With the discussion about backups, I would like to raise a quest

Re: [GTALUG] Testing Restore of mySQL Database

2016-12-23 Thread Alvin Starr via talk
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 th

Re: [GTALUG] Testing Restore of mySQL Database

2016-12-23 Thread Mauro Souza via talk
Restore on another database? Or in a virtual machine? Or in a container? On Dec 23, 2016 6:08 PM, "Dave Cramer via talk" wrote: > back it up on another machine > > Dave Cramer > > On 23 December 2016 at 14:59, Stephen via talk wrote: > >> With the discussion about backups, I would like to raise

Re: [GTALUG] Testing Restore of mySQL Database

2016-12-23 Thread Dave Cramer via talk
back it up on another machine Dave Cramer On 23 December 2016 at 14:59, 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

[GTALUG] Testing Restore of mySQL Database

2016-12-23 Thread Stephen via talk
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.