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

Restoring partial backup

jimjjimj EntrantInactive User Role Beginner
Hello, have a question on restoring partial backups with Xtrabackup.

Following the instructions in:
http:// www.percona.com/doc/percona-xtrabackup/innobackupex/partial_ backups_innobackupex.html?highlight=partial

I was able to successfully backup the partial and run the prep with the --apply-log and --export. From that point I got the new ibdata1 & ib_logfile's ready to be moved to a clean datadir on the target.

The howto mentions the .exp files being created but wondering if I need these files after running:

innobackupex --apply-log --export /temp/backups/2012-06-12_14-47-47

I did delete the files and all works alright, but just wondering if I'm missing something.

Are the .exp files only needed if going this route:
http:// www.percona.com/doc/percona-xtrabackup/innobackupex/importin g_exporting_tables_ibk.html ?

Also, another thing I noticed is the database is much larger in size now. It was 565M on the source and is now 1.8GB after the prep.

Any ideas why?

thanks,
jim

Comments

  • ameliataylorameliataylor Entrant Inactive User Role Beginner
    I have recently started working on partial backups.Will get back to you as soon as i get the solution.
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.