I have just inherited the job of administering a database from another guy who did not leave the company on good terms (I won't be able to ask him anything)

When I tried backing up the database by doing a database dump I got the following error:

mysqldump: Got error: 1017: Can't find file: 'tblFavoriteOwners' (errno: 2) when using LOCK TABLES

On a bit of further inspection, I found that the table tblFavoriteOwners appears when I run SHOW TABLES

However, any attempts to access anything specific about this table for instance DESCRIBE tblFavoriteOwners result in the following error:

ERROR 1017 (HY000): Can't find file: 'tblFavoriteOwners' (errno: 2)

Is there anything I can do to rescue this table, or should I just try dropping it in order to properly backup the rest of the database?

Thanks a lot

Try "Check Table" & "Repair Table" for your table if it is MyISAM table.

When I tried CHECK TABLE tblFavoriteOwners I get the following response:

Table: beds.tblFavoriteOwners
Op: Check
Msg_type: error
Msg_text: Can't find file: 'tblFavoriteOwners' (errno: 2)

When I do REPAIR TABLE tblFavoriteOwners I get the same response except Op is obviously repair instead of check.