Sessions crash / no phpmyadmin

[P55]

For the first time ever, a system here is throwing this error:

SQL Error:
145 - Table './mybb_db/mybb_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM mybb_sessions WHERE uid='1' LIMIT 1

There is no phpmyadmin on the associated machine, and it cannot be installed at this time.

Can anyone specify the exact procedure to clear the session table without phpmyadmin? Also, how can maintenance mode be entered before this process, when all attempts to access the board result in the same error? Thanks.

[Dylan M.]

It wouldn't matter if you cleared it, you need mysql access of some kind to repair the table. You can do it with the mysql commad line interface of phpMyAdmin (which I saw you cannot install). If you cannot use either of these, then you need to contact your host.

[Yaldaram]

Run This query in phpmyadmin;

PHP Code:

REPAIR TABLE `mybb_sessions`; 


[P55]

I have direct access to mysql on the host, but I need to know the proper command sequences. Thanks.

[Dylan M.]

log into it, and run the SQL Yaldarrm posted above on that table. Thats it.

[P55]

Thanks. I also did manage to get phpmyadmin up, so everything should be easier in the future.