MyBB Community Forums

Hello! We had an issue where mybb_searchlog corrupted and we couldn't repair it via shell or phpmyadmin which really sucked and it was looking as if we'd have to lose several weeks worth of posts on a big board (millionish posts). 

It frankly took a while to correct this; I seen issues about the tables becoming crashed for mybb_sessions and some recommended using HEAP instead of MyISAM for this. Would HEAP work for mybb_searchlog without errors? 

If I were you I'd look at errors logs more carefully cuz databases don't just go corrupt out of nowhere.

Also the searchlog is temporary (Usually cleaned every 24 hours iirc) thus that would most likely work but I wouldn't really recommend it too much as I haven't tested it as I have ours sat to InnoDB.

So yes, you can just empty it and change it to InnoDB or HEAP out anything really being lost.