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

Backup workflow and restoring single tables

noodlesnznoodlesnz ContributorInactive User Role Beginner
I've just started playing with innobackupex as a replacement for mysqldump. I'm just trying to work out how to best use compression/xbstream in my backups.

If I run innobackupex and then do an --apply-log when do I use --compress and/or xbstream? I'm trying to work out a way that I could restore a single table from a backup without having to download the whole backup file (which is 30GB+ uncompressed)

Is it possible to extract a single table/database from xbstream or is it just easier to not use xbstream and backup all the individual table files instead?

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.