Hello, I want to use Xtrabackup to do non blocking backups of our MySQL databases but also want to maintain the ability to restore by table rather than just entire database. As such I came upon a article which I thought was quite relevant,[url]Percona XtraBackup. It seems to imply that after running “xtrabackup --backup […]” the innobackupex export command should be run instead of preparing with xtrabackup. I’ve tried doing that but no *.exp files were made. Is there something I’m missing?
Nevermind, I figured out from [url]http://www.mysqlperformanceblog.com/2012/01/25/how-to-recover-a-single-innodb-table-from-a-full-backup/[/url] that what I wanted to run was:
innobackupex --ibbackup xtrabackup --no-timestamp --password= --export /var/lib/mysql-backups/date +"%Y-%m-%d"/