MyBB MySQL Problem

[hydrothunder]

Hi Legends,,,,

I am Facing a Serious Issue with my DB.......

I got error with MySQL

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
145 - Table './postleec_latest/mybb_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM mybb_sessions WHERE ip='173.242.118.31'

and some times

SQL Error:
1030 - Got error 28 from storage engine
Query:
SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'

Kindly help me...

I even Tried to Repair the table....But no use...

 

[NewEraCracker]

login over SSH and run.

mysql -u yourusername -p yourdatabase

Replace yourusername with the db username and yourdatabase with the db name (postleec_latest)

Then run:

REPAIR TABLE mybb_sessions;
exit;

Also, about Error 28, after running commands above run:

df -h

If 'Size' is higher than 'Used' but 'Use%' is 100%, it could indicate your host has ran out of space.

 

[PEDIA]

http://php.about.com/od/mysqladministration/qt/repair_mysql.htm