Shinguz: MySQL Enterprise Incremental Backup simplified

http://ift.tt/1wezd0Q

Taxonomy upgrade extras: mebMySQL Enterprise BackupenterpriseBackupincremental backupMySQL 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... Prepare MySQL Backup infrastructure mkdir /backup/full /backup/incremental1 /backup/incremental2Full 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-logFirst 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-backupSecond 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-backupand so on... MySQL Restore mysqlbackup --defaults-file=/etc/my.cnf --user=root --backup-dir=/backup/full copy-backHave fun with MySQL Enterprise Backup. If you need any help with your MySQL Backup concept, please let us know.

from Planet MySQL http://ift.tt/1du18ol