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