XNSIO
  About   Slides   Home  

 
Managed Chaos
Naresh Jain's Random Thoughts on Software Development and Adventure Sports
     
`
 
RSS Feed
Recent Thoughts
Tags
Recent Comments

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.

Tiki Wiki Error due to MySQL Table Crash

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


    Licensed under
Creative Commons License