I got this MySQL error today...

I got this MySQL error today.



Anybody know what might have caused this and how I can avoid this in the future.



This is not dedicated hosting, so the MySQL server is managed by the provider.

Firefox_003.gif

The database table was not properly closed when the server was shut down / reset. You need to execute the REPAIR TABLE command in MYSQL.



REPAIR TABLE





Also, the following command can be run from the root of the server:



myisamchk /*.MYI -u -p




From what I recall of the cs cart code, it is self recovering and automatically repairs crashed database tables. If you are seeing this error repeatedly, you’ll want to inspect your MySQL install for issues. MySQL should always be shut down properly before restarting the server so that it can commit table writes to disk.