Hello everybody,
I’m new on Xtrabackup and we have to test it before use it in production.
I’ve a problem when I try a restore. I create a “aaa” table with 2 records inside the “test” database.
The backup is done successfuly on another server as that:
innobackupex --user=user_backup --password=user_password --stream=tar ./ | ssh root@remote_host “cat - > /var/tmp/backup.tar”
Then I would like to try a restore of a test table name “aaa”.
So here are my command:
tar -xif backup.tar
innobackupex --apply-log --export /var/tmp/backup
Then I go to my MySQL VM and do that:
I remove and create again the table with the same structure.
mysql> use test;
mysql> set FOREIGN_KEY_CHECKS=0;
mysql> ALTER TABLE aaa DISCARD TABLESPACE;
Then I rsync the ibd file from the extract backup to the MySQL VM:
rsync -avz aaa.ibd root@mysql_vm:/var/lib/mysql/data/test/
ON MySQL again:
chown mysql: aaa.ibd
mysql> use test;
mysql> set FOREIGN_KEY_CHECKS=0;
mysql> ALTER TABLE aaa IMPORT TABLESPACE;
But after the IMPORT command I get this error:
#1030 - Got error -1 from storage engine
I try the same process with adding the .exp file but I got same error.
I use MySQL 5.5.41.
I’m helping with heses link:
[url]Percona XtraBackup
[url]https://www.percona.com/blog/2012/01/25/how-to-recover-a-single-innodb-table-from-a-full-backup/[/url]
Somebody get the same problem before ?
I don’t find why and how to solve this error…
It seams to be easy when we would like to restore a complete database, but sometimes we have to restore only on table and not the complete database…
Thanks a lot if you can help me !