Hi
I have a problem on restoring myincremental backup.
I did Following:
First, I make full backup in day one:
innobackupex -user=root -password=123 --no-timestamp mysqlbackup/incremental/base
innobackupex -user=root -password=123 --apply-log --redo-only mysqlbackup/incremental/base
then after some changes in day two I make a incremental in day two:
innobackupex -user=root -password=123 --no-timestamp --incremental mysqlbackup/incremental/inc01 --incremental-basedir=mysqlbackup/incremental/base
innobackupex -user=root -password=123 --apply-log mysqlbackup/incremental/base --incremental-basedir=mysqlbackup/incremental/inc01
innobackupex --apply-log mysqlbackup/incremental/base
And, restored it in day 3:
/etc/init.d/mysqld stop
mv /var/lib/mysql/ /var/lib/mysql-old
innobackupex -user=root -password=123 --copy-back mysqlbackup/incremental/base
chown -R mysql:mysql /var/lib/mysql/
/etc/init.d/mysqld start
But i were wondered when I see, the changes of day two (incremental backup) not applied to backup.
Does anyone know what the problem is?
Thanks in advance
morteza.
Software and versions
CentOS 6.2
Mysql 5.1
xtrabackup : last version from percona repository ,last weak