I’ve have a problem when restoring specific table, and i’m not sure what’s wrong because I’ve managed to do specific restores in the past
After the restore process:
- Discard Tablespace
- cp exp & ibd files
- Import Tablespace
any query run against this table response with “Lost connection to mysql during query”
in the error log i see
“InnoDB: Error: tablespace id is 10 in the data dictionary
InnoDB: but in file ./db/table.ibd it is 968465!
160118 14:34:57 InnoDB: Assertion failure in thread 140720242185984 in file fil0fil.c line 778
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: about forcing recovery”
I’m using Percona-xtrabackup-2.1.8-733
The Source server is Percona - 5.5.29
The Destination server is Percona - 5.5.38
Thanks in advance