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?