How it works?
XtraBackup basically does a copy of ‘/var/lib/mysql’ – no dumps. So, it’s good for a full restore but a bit tricky for a specific db restore.
So, the following steps will create a second MySQL instance using dbsake utility (the version can be specified, but the below example uses the version currently running on the server), extracting only the specific backup (to save space) and from there, you will be able to extract the dump with the well known ‘mysqldump‘.
>> Download dbsake. Bear in mind it requires python2.6 which can be installed from IUS.
curl -s http://get.dbsake.net > dbsake
chmod +x dbsake
>> Install pigz from EPEL repo
yum install pigz
>> Use dbsake to unpack Percona XtraBackup stream extracting only the DB required
screen -S xtrabackup_restore
./dbsake sandbox --sandbox-directory=/tmp/sandbox/ \
--data-source=/var/spool/holland/xtrabackup/newest/backup.tar.gz -t <database_name>.*
>> Start a dbsake instance and dump the required database.
/tmp/sandbox.sh mysqldump <database_name> | gzip -1 ><database_name>.sql.gz
>> Clean up
rm -rf /tmp/sandbox