How to use Mysql:mysql Enterprise Backup

How to use Mysql:mysql Enterprise Backup

For MySQL hot spares use the most should xtrabackup tools,

But this tool does not have a window version, just our company those wonderful to put MySQL

Installed on the window, the first time using the mysqldump backup has no effect on the system,

After a large amount of data, the estimation system can not withstand, I have to study MySQL Enterprise Backup,

MySQL Enterprise Backup This tool has a lot of features, personal feel most useful, on full-scale backup and incremental backup,

So I focused on full backup and incremental backup.

================= full standby and recovery ==================================

# Full Backup

# Back up the database

Mysqlbackup--user=root-p--backup-dir=d:\backup\mysqlbackup Backup-and-apply-log

# Restore the database and need to stop the MySQL service before recovering the database

net stop MySQL

Mysqlbackup--defaults-file= "C:/Program files/mysql/mysql Server 5.5/my.ini"--backup-dir=c:/mysqlbackup Copy-back-and-apply-log

============ incremental backup and restore ========================================

# Incremental Backups First incremental backup on a fully prepared basis, the second incremental backup is based on the first incremental backup

# fully prepared

Mysqlbackup--user=root-p--backup-dir=d:\backup\mysqlbackup Backup-and-apply-log

# First Incremental backup

Mysqlbackup--defaults-file= "C:\Program files\mysql\mysql Server 5.5\my.ini"--user=root [email protected]-- Incremental--incremental-base=dir:d:\backup\mysqlbackup--incremental-backup-dir=d:\backup\incre01 BACKUP

# A second incremental backup

Mysqlbackup--defaults-file= "C:\Program files\mysql\mysql Server 5.5\my.ini"--user=root [email protected]-- Incremental--INCREMENTAL-BASE=DIR:D:\BACKUP\INCRE01--INCREMENTAL-BACKUP-DIR=D:\BACKUP\INCRE02 BACKUP

----Start the recovery phase-----------

# merge the first backup into full standby

Mysqlbackup--backup-dir=c:\mysqlbackup--incremental-backup-dir=c:\incre01\incre01 Apply-incremental-backup

#将第二个备份合并到全备中.

Mysqlbackup--backup-dir=c:\mysqlbackup--incremental-backup-dir=c:\incre02\incre02 Apply-incremental-backup

#最后一步 Restore Data

Mysqlbackup--defaults-file= "C:/Program files/mysql/mysql Server 5.5/my.ini"--backup-dir=c:/mysqlbackup Copy-back-and-apply-log

How to use Xtrabackup:

http://dwchaoyue.blog.51cto.com/2826417/1429918

MySQL Enterprise Backup Feature Description:

Http://www.mysql.com/products/enterprise/backup.html

MySQL Enterprise Backup User manual:

Http://wenku.baidu.com/link?url=W_ Fxtp3tkq61eakec5xd7zj5t4gmaxfdlzfmdw6evzi8y4asuisv5tnp29yaln9p--w-rik16wco5yumhiapo7gxk5t6yit_2wmruenvrbs

This article is from the "SQL Server MySQL" blog, reproduced please contact the author!

How to use Mysql:mysql Enterprise Backup