Description:
It would be good to do an incremental backup based directly on mbi file without the need to extract metadata from it or read it from backup-dir
for example :
when you have full backup on the sunday :
incremental backup each 2 hours (to avoid the need of backuping binlog... with some script)
and differential backup each day.
In this cas we cannot use --incremental-base=history:last_backup but only the dir: method
How to repeat:
do a full backup :
mysqlbackup -uroot --backup-image=/backups/mbi/test.mbi --backup-dir=/backups/tmp backup-to-image --with-timestamp
now : do an incremental backup based on it
mysqlbackup -uroot - --backup-image=/backups/mbi_incr/toto_inc1bis.mbi --incremental-backup-dir=/backups/tmp_incr backup-to-image --incremental --backup-dir=/backups/tmp --incremental-base=dir:/backups/tmp
but for the differential backup we need to keep backup-dir but the single file mbi is disappointed if it needs a directory with some files. The solution is to extract metadata. but it is really annoying to make a backup
Suggested fix:
the suggest way :
mysqlbackup -uroot - --backup-image=/backups/mbi_incr/toto_inc1bis.mbi --incremental-backup-dir=/backups/tmp_incr backup-to-image --incremental --backup-dir=/backups/tmp --incremental-base=MBI:/backups/mbi/test.mbi
