Re: Site Attack/Failure Recovery

[John Comerford <johnc@xxxxxxxxxxxxxxxxxxxx>]

I have worked as a DBA for a long time, just not with MySQL and I have 
spent a lot of time making sure the application is secure.  I suppose my 
question was really what is the best way to do incremental backups?  The 
DB I have most experience with has thing like after imaging etc. which 
allows you to easily roll A DB forward to a particular point in time, 
making disaster recover pretty straight forward.  I am wondering if 
there is such a thing in MySQL  or is there a product/scripts that are 
considered the "standard" for doing this sort of thing?


Rob Wultsch wrote:
> On Wed, May 14, 2008 at 11:13 PM, John Comerford
> <johnc@xxxxxxxxxxxxxxxxxxxx> wrote:
>   
> > Quickly scanning this page, it doesn't seem to give syntax for an
> > incremental backup.  I am hoping to be able to run something that dumps only
> > data changed since the last backup.
> >
> >     
>
> You could use diff and the previous dump to generate a incremental
> dump. I very much suggest against this.
>
> If you don't spend the time to really understand what is going on then
> you are going to end up hosed without a good backup to revert to. I
> suggest that if don't know how to sanitize input then you are over
> your head. People get paid a lot of money to to be DBA's, and good
> chunk of that is understanding disaster mitigation/recovery.
>
> K.I.S.S.: words to live by.
>
>   


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx