MySQL Error: Incorrect key file for table 'blog_usercss'

[CPOWA]

Tried backing up my database this morning and I'm getting the error below. Never had any trouble backing up before. Only changes made to the system since the last backup: Upgraded php (from 5.2.4 to 5.2.11) and mysql (from 4.1.22 to 5.1.37). Restoring the DB is not an option. IE: New users, Style, etc.

Repair table tool didn't fix it. Also, there are no records on the blog_usercss table.

What to do?

Database error in vBulletin 3.8.3:

Invalid SQL:
SHOW CREATE TABLE blog_usercss;

MySQL Error : Incorrect key file for table 'blog_usercss'; try to repair it
Error Number : 1034
Request Date : Sunday, November 22nd 2009 @ 10:04:54 AM
Error Date : Sunday, November 22nd 2009 @ 10:04:57 AM
Script : http://www.uspatriotsnation.com/foru...php?do=sqlfile
Referrer : http://www.uspatriotsnation.com/foru....php?do=choose
IP Address : XXXXXXX
Username : XXXXXXX
Classname : vB_Database
MySQL Version : 5.1.37

[Trevor Hannant]

Run this query in phpMyAdmin rather than through AdminCP:

REPAIR TABLE blog_usercss;

If the table's empty, you could drop it and recreate it? Make sure you backup before trying that though...

[CPOWA]

Thanks for the advice Trevster. I tried the repair in phpmyadmin. No joy.

SQL result

Host: localhost
Database: xxxxx_forums
Generation Time: Nov 23, 2009 at 09:05 AM
Generated by: phpMyAdmin 2.11.9.5 / MySQL 5.1.37
SQL query: REPAIR TABLE `blog_usercss`;
Rows: 2
Table Op Msg_type Msg_text xxxxx_forums.blog_usercss repair Error Incorrect key file for table 'blog_usercss'; try to repair it
xxxxx_forums.blog_usercss repair error Corrupt

Also, phpmyadmin is reporting the table blog_usercss table status as "in use".

[Trevor Hannant]

I'd give your host a shout and ask them to look at it for you

[CPOWA]

Host just tried. Not good:

mysql> repair table blog_usercss;
+---------------------------+--------+----------+---------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------+--------+----------+---------------------------------------------------------------+
| cpowa_forums.blog_usercss | repair | Error | Incorrect key file for table 'blog_usercss'; try to repair it |
| cpowa_forums.blog_usercss | repair | error | Corrupt |
+---------------------------+--------+----------+---------------------------------------------------------------+
2 rows in set (0.00 sec)

[CPOWA]

Could someone move this thread to theBlog Questions, Problems and Troubleshooting forum. Thanks.