Question - Apply Logs - Tar backup

Asked by saurya1979 on 2011-02-23

Hello,

I am not sure if I have understood correctly. I am using following command to make backup but I am confused on how to apply logs to backup data so as to bring it to consistent state.

innobackupex --stream=tar ./ | gzip - > backup.tar.gz

It will prepare tar.gz file that has the backedup data. How can I use it to restore?

Thanks,
Saurya

Question information

Language:
English Edit question
Status:
Answered
For:
Percona XtraBackup moved to https://jira.percona.com/projects/PXB Edit question
Assignee:
No assignee Edit question
Last query:
2011-02-23
Last reply:
2011-02-28

First untar the archive:

tar -xzfi backup.tar.gz

Then apply the logs:

innobackupex-1.5.1 --apply-log /path/to/your/uncompressed/backup

You should (bug 723097 notwithstanding) then have a set of files that you can point mysql's datadir at.

Can you help with this problem?

Provide an answer of your own, or ask saurya1979 for more information if necessary.

To post a message you must log in.