var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: is this table corrupted??
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:
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.