Search for questions :
My Profile
Categories

JimmyRead

Open Question Bookmark and Share

I am having “Error 17803” in MySQL Database ?

I am getting the above mentioned error and as a result of which the database ends up being corrupted. I think that it might be because of some kind of hardware failure. Due to the damaged database, I am not able to get access to the tables in the corrupted database. Can anybody give me a possible solution to get rid of this error message and repair the damaged database?

352 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)

NancyJohnson 		You can get the damaged MySQL Database repaired by setting the database to emergency mode by using the below mentioned script:

• Update sysdatabases set status= 32768
• Repair the database using DBcc command with option Repair_Rebuild
• Then sp_dboption 'your database name', 'single_user', 'true'
• dbcc checkdb ('your database name', REPAIR_REBUILD)
• Execute DBcc again to check your database integrity after repair action

By going through these operations the MySQL database that has gone damaged will be repaired and then you will be able to access to the tables in the repaired database.


Posted 352 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