Learn how to a build a cloud-first strategyRegister Now


Unable to repair database table

Posted on 2012-08-13
Medium Priority
Last Modified: 2012-08-14
I have searched & found that this error is common in Magento sites:
"SQLSTATE[HY000]: General error: 145 "

It's usually solved by repairing the crashed database but when I try to do this, phpmyadmin says that the php function has been run successfully, but then says the operation failed & the database remains crashed.

Can anyone help?
Question by:TonyCabone
LVL 17

Expert Comment

ID: 38291815
Hi, been a long time since I worked with phpmyadmin, but did  you repair the database or the specific table referenced in the error (I am guessing it referenced a specific table).
LVL 31

Accepted Solution

hnasr earned 2000 total points
ID: 38292531
Try this to keep going, then think of finding a better solution.

If you know the problem table, drop it and try to rebuild it from a backup.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses
Course of the Month21 days, 1 hour left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question