Re: Site Attack/Failure Recovery

[John Comerford <johnc@xxxxxxxxxxxxxxxxxxxx>]

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.



Rob Wultsch wrote:
> On Wed, May 14, 2008 at 10:25 PM, John Comerford
> <johnc@xxxxxxxxxxxxxxxxxxxx> wrote:
>   
> > 2) Incremental Backups - say one every half hour, then a script to transfer
> > that to an off site machine that way I can get the DB back to within the
> > last good half hour...
> >     
>
> http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
>
> Being compromised is not inevitable, but hardware failure is. Having
> trusted (an therefore tested) backups is the only way to operate. Is
> there some practice in particular you are concerned about?
>
> Blanket suggestion: Don't escape things manually, have the db (or
> emulation) do it for you using prepared statements. It is easier to
> code this way, and much more secure in the long run.
>
>   


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