Continue to get MySQL table crashed error on TikiWiki
A few months ago I had an exact same issue but with a different table. This time tiki_sessions table crashed.
I still don’t understand what is causing the crash. Luckily I know how to get rid of this issue quickly once I discover it.
executing the following command fixes the issue:
mysqlcheck –auto-repair -u{username} -p{password} {database_name} {database_table_name}
output:
{database.name}.tiki_sessions
error : Table ‘./{database.name}/tiki_sessions’ is marked as crashed and should be repaired
Repairing tables
{database.name}.tiki_sessions
warning : Number of rows changed from 0 to 2
status : OK