Bug #100797 | after restert DB, alter table t import tablespace fail | ||
---|---|---|---|
Submitted: | 10 Sep 2020 11:37 | Modified: | 28 Sep 2020 14:52 |
Reporter: | aceking king | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | mysql-8.0.21 | OS: | Linux |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[10 Sep 2020 11:37]
aceking king
[28 Sep 2020 14:52]
MySQL Verification Team
Hi, This is not a bug, you are not following the procedure properly. CREATE TABLE t1 (c1 INT) ENGINE=INNODB; ALTER TABLE t1 DISCARD TABLESPACE; FLUSH TABLES t1 FOR EXPORT; -- this you missed shell> cp t1.ibd t2.ibd shell> cp t1.cfg t2.cfg # you missed the .cfg file too UNLOCK TABLES; -- this deletes the cfg file ... all best Bogdan