You are here

Incremental Backup with MEB

Hello all,

I found it difficult to understand Incremental Backup with MEB. Has anybody done it before?

Hi Oli

First you have to do a full backup. We did it as follows:

mysqlbackup --defaults-file=/etc/my.cnf --user=root --backup-dir=/backup/full backup
mysqlbackup --defaults-file=/etc/my.cnf --user=root --backup-dir=/backup/full apply-log

Then you can do the incremental backup:

mysqlbackup --defaults-file=/etc/my.cnf --user=root --incremental --incremental-base=dir:/backup/full --incremental-backup-dir=/backup/incremental1 backup
mysqlbackup --defaults-file=/etc/my.cnf --user=root --backup-dir=/backup/full --incremental-backup-dir=/backup/incremental1 apply-incremental-backup

this incremental backup you can repeat several times...

Hope this helps?
Shinguz

Shinguzcomment