Loading...
 
Features / Usability

Features / Usability


Corrupt db table?

posts: 3665 United States

Help sad

I'm getting intermittent warnings on one of my Tiki sites:

Warning: mysql error:
Table './tiki_searchindex' is marked as crashed and should be repaired in query



Can anyone explain to me:

  • What went wrong (how/why did it crash)?
  • What is wrong with the query?
  • How do I fix this?


Tx,

-Rick

posts: 104

> Help sad
>
> I'm getting intermittent warnings on one of my Tiki sites:
>
> Warning: mysql error:
> Table './tiki_searchindex' is marked as crashed and should be repaired in query
>

Probably nothing wrong with TW afaik. I had the same problem a year ago. After a nice talk with my provider, I was told, that this is quite common with MySQL databases. Although MySQL is cheap (for free) it's maintenance is not. If you don't have a dedicated DB service, you are responsible for checking the consistency of your MySQL DB yourself.

You can easily do this with phpmysql. Select the DB and table and check for consistency. If problems are found you do have the option to run a repair. Prepare a backup before doing this!

In your case, you are lucky, because all your data is still there! In my case, I found the DB error only after a backup failed! Because MySQL doesn't backup after it dedects an error, half of my data was simply gone. I was under the impression, that backups are fine for month, but you can't be sure if you do have an inconsistent db, and even worse: you dont't get a notification about this!

Go, switch to different DB, stay away from MySQL ....

Best regards, Bernhard

posts: 3665 United States


>
> You can easily do this with phpmysql. Select the DB and table and check for consistency. If problems are found you do have the option to run a repair. Prepare a backup before doing this!
>

When I do a backup, it shows only 1K total size?!?!