Search  
   
Browse by Category
 
Netfirms 24/7 Support .: DATABASE MANAGEMENT .: How do I repair a corrupt MySQL tables?

How do I repair a corrupt MySQL tables?

The following similar database error may be fixed by running a repair on the specified database table: "Can't open file: 'phpbb_topics.MYI' (errno: 144)."

Here are the steps to repair a table in your database:

Option #1:

1. Log into the Netfirms Control Panel at https://controlpanel.netfirms.com
2. Click Site Tools
3. Click Database Manager
4. For the databse in question, click Admin
5. Click phpMyAdmin
6. Click on the database name
7. Click the SQL tab
8. In the box, enter the following query (where table_name is the name of the table being referenced in the error message): repair table table_name
9. Click Go

Option #2:
1. Log into the Netfirms Control Panel at https://controlpanel.netfirms.com
2. Click Site Tools
3. Click Database Manager
4. For the databse in question, click Admin
5. Click phpMyAdmin
6. Click on the database name
7. Use the checkbox to check off which table you wish to repair. (Or scroll down and click the Check All link if you want to repair your entire database)
8. From the With Selected pull-down menu, select Repair table



How helpful was this article to you?


.: Powered by Lore 1.5.6
Visit Netfirms.com Web Hosting | Copyright © 1998 - 2006 Netfirms, Inc. All Rights Reserved.