New User ? Sign Up  |  Sign In  |  Help
Download Best iPod Data Recovery Software
ask
answer
discover
     
Search for questions :
My Profile
Download Best iPod Data Recovery Software
Categories
Download Best iPod Data Recovery Software

Lipranzer

Open Question Bookmark and Share

How to get rid of error message in MySQL Database ?


Download Best iPod Data Recovery Software

I am getting the following error message while running a particular table in MySQL database:

Server: Msg 2511, Level 16, State 2
Table Corrupt: Object ID %d, Index ID %d. Keys out of order on page %S_PGID, slots %d and %d.
Table error: Object ID %d, Index ID %d. Keys out of order on page %S_PGID, slots %d and %d.

Can anyone give me possible repair solution to get rid of the abovementioned errors?

875 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

Nauman 		To get rid of the error messages, you would need to repair the damaged table of the MySQL Database. Use the following command to repair the corrupt table: Check Table XYZ.

After running this command, use any of the 2 commands to repair the damaged table:

•REPAIR TABLE `Name of the table` USE_FRM
•mysqlcheck -r -u username -ppassword d60476544 “Name of the table”

With the help of these commands, the damaged table is repaired and you would be able to get access to its contents. Even then the problem persists, then I would advise you to use MySQL Database Repair software. This software through its sophisticated program would repair the damaged table of the database.


Posted 875 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0
Download Best iPod Data Recovery Software