March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031

Categories

March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031

MySQL Enterprise Backup (MEB)

MySQL Enterprise Backup (MEB) has the capability to make real incremental (differential and cumulative?) backups. The actual releases are quite cool and you should really look at it…

Unfortunately the original MySQL documentation is much too complicated for my simple mind. So I did some testing and simplified it a bit for our customers…

If you want to dive into the original documentation please look here: Making an Incremental Backup .

If you want to use MySQL Enterprise Backup please let us know and we send you a quote

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…
FULL MYSQL BACKUP
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
FIRST MYSQL 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
SECOND MYSQL INCREMENTAL BACKUP
mysqlbackup –defaults-file=/etc/my.cnf –user=root –incremental –incremental-base=dir:/backup/full –incremental-backup-dir=/backup/incremental2 backup
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full –incremental-backup-dir=/backup/incremental2 apply-incremental-backup

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>