Results 1 to 3 of 3

Thread: Table Crashed

  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: Table Crashed

    When I am making certain modifications in the xyz table. While doing so, I encounter a power outage and my system shuts down unexpectedly. Again I switch on my system and try to open the table, the following error message gets displayed:

    “Table is crashed and last repair failed”

    The data saved in the xyz table becomes inaccessible after the error occurrence.

    Tell me what to do to recover my data.
    Last edited by sam.joseph74; 06-03-09 at 06:13.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    try issuing a REPAIR command
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2009
    Posts
    6

    Re: Table Crashed

    To resolve the above error message, you will need to repair xyz.myi table by using these steps:

    1. To check and analyze the corrupted table, use either of the two commands:
    myisamchk xyz.myi
    Or
    Check Table xyz
    2. To repair the corrupted table, use either of the two commands:
    myisamchk -r –q xyz (-r -q means “quick recovery mode”)
    Or
    Repair Table xyz

    But if the above repair commands fail to repair the xyz table, you need to repair the table by using powerful MySQL Repair software. Such MySQL Database Repair applications incorporate advanced scanning algorithms to repair and restore the data stored in MyISAM tables. I would suggest Stellar Phoenix Database Recovery For MySQL to repair and recover corrupted MySQl database.

Posting Permissions

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