SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru
    Join Date
    Oct 2001
    Location
    USA
    Posts
    764
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Angry Mysql db table error

    When I try and edit this table by running this code I get the following.

    DELETE FROM members WHERE email = 'you@email.com'

    MySQL said: Incorrect key file for table: 'members'. Try to repair it

    Then I try to repair it and it says

    the handler for the table doesn't support check/repair

    Anyone know how to fix this? Please help...I'm desperate....and it's my birthday, if you could help me it would be the best present yet.

  2. #2
    Shiver me timbers!! anthony_irl's Avatar
    Join Date
    Aug 1999
    Location
    Dublin, Ireland
    Posts
    495
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://www.mysql.com/doc/C/o/Corrupt...AM_tables.html

    http://www.mysql.com/doc/R/e/Repair.html

    Have you followed those instructions? If you have then try running this command:
    ALTER TABLE tbl_name TYPE = MYISAM
    and then run:
    OPTIMIZE TABLE tbl_name

    For more info on Optimize please see: http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html

    Hope that helps.
    Anthony - How's tings?

    24 hours in a day, 24 beers in a case. Coincidence? I think not.
    Contact me by: PM Email NEW! Carrier Pigeon

  3. #3
    SitePoint Guru
    Join Date
    Oct 2001
    Location
    USA
    Posts
    764
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    can you tell me exactly what this command does?

    ALTER TABLE tbl_name TYPE = MYISAM

  4. #4
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ouch, nasty errors. that query probably won't do anything. try running

    CHECK TABLE table

    and

    REPAIR TABLE table

    to check and/or [attempt to] repair the table. see what happens.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  5. #5
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to a more appropriate forum

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature


Bookmarks

Posting Permissions

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