MySQL - 删除.frm和.ibd文件后能够访问数据库

Question

I have a MySQL server which is running with out any error. Accidentally i removed all .ibd and .frm files. But server is not throwing any error. It continue data insert and all operations even using command line.

I found that its using ibdata files temporarily to stored and access the records.

If i try to access all records it show no records found. and it show no tables available for 'show tables' but it doesn't throw any error message if i access using particular table name

How do i over come this scenario. If any .ibd or .frm file is deleted it should throw error if i access the table.

Answer 1

Try CHECK TABLE my_table EXTENDED;

Edit:

REPAIR TABLE tbl_name EXTENDED should help you to bring back corrupted data. Please make a backup of the table itself and the whole database first.