!Error: MySQL Error Code: (145) - Table '.\paranoid\_main' is marked as crashed

Spam-detecting plug-in
Junior Member
Posts: 2
Joined: Fri Jul 18, 2008 4:31 pm

!Error: MySQL Error Code: (145) - Table '.\paranoid\_main' is marked as crashed

Postby stjack1 » Fri Jul 18, 2008 4:38 pm

Help! I am getting this error:
!Error: MySQL Error Code: (145) - Table '.\paranoid\_main' is marked as crashed and should be repaired

It comes between Maintenance Started and Maintenance Finished in the Paranoid logs. I am getting no filtering since this started happening. I don't know much about MySQL. I don't know where the database is located or how to repair it.

Thanks for any help!
Steve

Developer
User avatar
Posts: 4431
Joined: Tue Apr 20, 2004 3:43 pm

Postby Alexander Telegin » Fri Jul 18, 2008 7:26 pm

Run MySQL client:

Code: Select all
Start -> Programs -> MySQL -> MySQL command line client.


Type the password and following lines:

Code: Select all
\u paranoid
repair table _main;

Junior Member
Posts: 2
Joined: Fri Jul 18, 2008 4:31 pm

Thanks!

Postby stjack1 » Fri Jul 18, 2008 9:11 pm

I had everything but the "_main" part. Also, I had to stop the paranoid service 1st, then start it afterward. Then I restarted Argosoft mail server.

Thanks so much for your help. I really appreciate it. Have a great weekend!

Steve

Junior Member
Posts: 1
Joined: Fri Aug 27, 2010 10:33 am

Postby SaltyDawg88 » Fri Aug 27, 2010 10:40 am

I am getting the same error and I have tried the same fix as suggested above but all i get is the screen below. It has a blinking cursor and i see no activity on my server. I let it sit for a couple of hours with no change. :confused:

Image

Developer
User avatar
Posts: 4431
Joined: Tue Apr 20, 2004 3:43 pm

Postby Alexander Telegin » Fri Aug 27, 2010 12:22 pm

The command should end with ;

Code: Select all
repair table _main;

Return to Paranoid - General

Who is online

Users browsing this forum: No registered users and 1 guest