Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    2

    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

  2. #2
    Join Date
    Aug 2005
    Posts
    30
    Try "Check Table" & "Repair Table" for your table if it is MyISAM table.

  3. #3
    Join Date
    Jul 2009
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •