Not the answer you need?
Register and ask your own question!

Point in time recovery question

prakash_balaprakash_bala EntrantInactive User Role Beginner
I am new to MySQL and innobackupex.

Took a base backup at time T0, made some changes and then took an incremental backup at time T1 and made some more changes and took another incremental backup at time T2.

I am able to restore to various times (T0, T1 and T2) and validate the changes.

Now I have some more changes after time T2 which exists only in the ib_logfile*. What additional commands I need to run after "innobackupex --copy-back /data2/mysql/full" so that I can see the latest changes after a restore?

Tried copying the ib_logfile* to a different destination before wiping out /var/lib/mysql, ran the above command and restored these files before starting mysql. But it did not work.

Thanks in advance!

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.