| 1 |
CREATE TABLE t1(f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INT, f3 CHAR, f4 TEXT) |
| 2 |
ENGINE=InnoDB; |
| 3 |
DELETE FROM t1 WHERE f1%2=0; |
| 4 |
FLUSH TABLES t1 FOR EXPORT; |
| 5 |
UNLOCK TABLES; |
| 6 |
DROP TABLE t1; |
| 7 |
CREATE TABLE t1(f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INT, f3 CHAR, f4 TEXT) |
| 8 |
ENGINE=InnoDB; |
| 9 |
ALTER TABLE t1 DISCARD TABLESPACE; |
| 10 |
SET SESSION debug="+d,ib_import_page_corrupt"; |
| 11 |
ALTER TABLE t1 IMPORT TABLESPACE; |
| 12 |
ERROR HY000: Operation cannot be performed. The table 'test.t1' is missing, corrupt or contains bad data. |
| 13 |
SET SESSION debug="-d,ib_import_page_corrupt"; |
| 14 |
DROP TABLE t1; |