MySQL Forums
Forum List  »  Backup

Re: mysqlbackup apply-incremental-backup failure
Posted by: Luis Stevens
Date: April 10, 2012 10:45PM

Very interesting. This "was" a full backup. I applied incremental backups
on it multiple times. The time the incremental backup application was killed mid-way, the full backup got into this "state". Does the process of applying an incremental backup ever change the is_incremental setting? Non-atomically?

Can I just change the setting to is_incremental=0 ?

BTW, this is very easily reproduce-able:
1. create a full backup
2. create incr backup
3. apply incr to full
4. create another incr backup
5. apply incr to full; kill -9 before it finishes
6. the full backup is now corrupt.

The "kill -9" is intended to emulate a machine reboot/power-loss. In either case
(kill -9 or reboot/power-loss) the full backup is corrupted.



Thanks!
Luis.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysqlbackup apply-incremental-backup failure
1739
April 10, 2012 10:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.