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
<[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]

Reply via email to