bin/xtrabackup --defaults-file=/home/admin/install/mysql/my.cnf --backup --target-dir=/home/admin/install/xtrabackup/data
xtrabackup: The latest check point (for incremental): '0:11841877'
bin/xtrabackup --defaults-file=/home/admin/install/mysql/my.cnf --backup \
--incremental-lsn=0:11841877 --target-dir=/home/admin/install/xtrabackup/data/20090724
bin/xtrabackup --defaults-file=/home/admin/install/mysql/my.cnf --backup \
--incremental-basedir=/home/admin/install/xtrabackup/data --target-dir=/home/admin/install/xtrabackup/data/20090724
----------------------------------------------------------------------------
binlog的清理
1.PURGE BINARY LOG(PURGE MASTER LOG)
2.my.cnf添加expire_logs_days=天数
xtrabackup: The latest check point (for incremental): '0:11841877'
bin/xtrabackup --defaults-file=/home/admin/install/mysql/my.cnf --backup \
--incremental-lsn=0:11841877 --target-dir=/home/admin/install/xtrabackup/data/20090724
bin/xtrabackup --defaults-file=/home/admin/install/mysql/my.cnf --backup \
--incremental-basedir=/home/admin/install/xtrabackup/data --target-dir=/home/admin/install/xtrabackup/data/20090724
----------------------------------------------------------------------------
binlog的清理
1.PURGE BINARY LOG(PURGE MASTER LOG)
PURGE BINARY LOGS TO 'mysql-bin.010';
PURGE BINARY LOGS BEFORE '2009-07-02 22:00:00';
2.my.cnf添加expire_logs_days=天数