Hi All,
Is there a simple way of checking when the backup db server performed
its last restore and whether it was successful or not. I need to ensure
that the dump and restore of the production box has run successfully
every night until proper backup/DRP procedures are in place. I'm not
Is my assumption correct that you dump your main production db and restore
it to a second server? And this restore is what you want to verify?
Olaf
On 7/21/08 8:34 AM, Warren Windvogel [EMAIL PROTECTED] wrote:
Hi All,
Is there a simple way of checking when the backup db server performed
its
Hi Warren,
R u using any tool/script for backup/restore procedure, if yes, then log
files generated by them should let u know, if they were successfull or
failed.
regards
anandkl
On 7/21/08, Warren Windvogel [EMAIL PROTECTED] wrote:
Hi All,
Is there a simple way of checking when the backup
Olaf Stein wrote:
Is my assumption correct that you dump your main production db and restore
it to a second server? And this restore is what you want to verify?
That is correct.
Warren
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
If you do the dump/restore by hand or shell script than the first indicator
is if the process finishes without errors. Then you could calculate
checksums of your tables on both boxes and compare them, this will obviously
only work if the production db has not changed since the dump.
Are you doing