Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups every half an hour (on our slave server).
Now for a scenario, where some how a table has been accidentally dropped, I thought recovery would be as simple as -
- copy .ibd and .frm file from backup to mysql data dir.
- alter table tbl_name import tablespace;
On issuing a select, DB throws an error - table does not exist. I understand this might have something to do with
Any ideas how to go about restoring table in this situation?