List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:November 7 2012 1:26pm
Subject:Re: How to verify mysqldump files
View as plain text  
you can use checksum to make sure there are not corruption in the file

On Wed, Nov 7, 2012 at 6:39 PM, Claudio Nanni <claudio.nanni@stripped>wrote:

> Gary,
>
> It is always a good practice to test the whole solution backup/restore.
> So nothing is better than testing a restore, actually it should be a
> periodic procedure.
> As for the validity of the file usually is delegated to the operating
> system.
> If you want to check it yourself you may create an algorithm that analyses
> some patterns in the dump file to recognize that it is correct,
> starting may be from one that is working as 'valid' sample.
>
> Cheers
>
> Claudio
>
>
>
> 2012/11/7 Gary <listgj-mysql@stripped>
>
> > Can anyone suggest how I could verify that the files created by
> > mysqldump are "okay"? They are being created for backup purposes, and
> > the last thing I want to do is find out that the backups themselves are
> > in some way corrupt.
> >
> > I know I can check the output of the command itself, but what if.. I
> > don't know... if there are problems with the disc it writes to, or
> > something like that. Is there any way to check whether the output file
> > is "valid" in the sense that it is complete and syntactically correct?
> >
> > --
> > Gary        Please do NOT send me 'courtesy' replies off-list.
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql
> >
> >
>
>
> --
> Claudio
>

Thread
How to verify mysqldump filesGary7 Nov
  • Re: How to verify mysqldump filesClaudio Nanni7 Nov
    • Re: How to verify mysqldump filesAnanda Kumar7 Nov
      • Re: How to verify mysqldump filesManuel Arostegui7 Nov
  • RE: How to verify mysqldump filesBenjamin Stillman7 Nov
    • RE: How to verify mysqldump filesRick James7 Nov