News:

Wondering if this will always be free?  See why free is better.

Main Menu

MySql table corruption problem

Started by Simplemachines Cowboy, May 27, 2006, 10:45:45 PM

Previous topic - Next topic

Simplemachines Cowboy

SMF Version: SMF 1.1 RC2
My host had a hiccup, and now I have a table that is corrupt.

It's the "log_actions" file.
InnoDB file with 402 records.

Can I drop and recreate without any effects to the forum?

And since I know nothing of sql, how do I do that?

TIA,

Cowboy
My SMF forum: The Open Range

Ben_S

You can, this table just holds the moderator log I beleive.

You could try doing a repair on it first though.
Liverpool FC Forum with 14 million+ posts.

Simplemachines Cowboy

#2
I should have said that I tried repair and it didn't work.

And that is the mod log file. I deleted the entries from the admin panel and now there is only 1 record.

OK, so I open phpmyadmin, and then... ???
Help me, Mr. Wizard!
;)
My SMF forum: The Open Range

Simplemachines Cowboy

I fixed it.
InnoDB doesn't support repair so I converted to MyIsam, repaired, and converted back.

Thanks Ben!
My SMF forum: The Open Range

Advertisement: