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@optionsystems.com.au> 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.
>
>