MySQL Forums
Forum List  »  Partitioning

MySQL 5.5 - can't discard tablespace for partitioned tables?
Posted by: Jan Andersen
Date: October 25, 2019 02:34AM

I have to restore a partitioned table from an old MySQL 5.5 backup, created with Percona's innobackupex. I have tried to import it into a newer version, but it fails due to incompatibilities around temporal data, so I have to use MySQL 5.5. The strategy involves:

- create the table from information in the .frm file
- discard the tablespace
- move the backup tablespace to the data directory
- import tablespace

However, when I try to discard the tablespace, I get an error:

ERROR 1031 (HY000) at line 1: Table storage engine for 'my_partitioned_table' doesn't have this option

I am sure I have done this before, but quite possibly in a more up-to-date version; is this not possible in MySQL 5.5?

Options: ReplyQuote

Written By
MySQL 5.5 - can't discard tablespace for partitioned tables?
October 25, 2019 02:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.