WARNING: mysqlcheck has found corrupt tables

When I log in to my acc via SSH, getting message "You have new mail". Opened mail and this is what I get:

To: root@XXX root@XXX
Subject: Re: WARNING: mysqlcheck has found corrupt tables

What the *uck is wrong ? It started after couple of power failures. I think I get a new mail everytime when I boot my server.
I'am using only SSH to config my server, so give me some shell commands pls.

 

You need to repair the corrupt tables.

 

Well theres not a lot tables to repair. But is that shell command something like "repair <table>"?

 

you do that for myisam tables from the mysql prompt

Code:

mysql> repair table <table_name>

 

Why it keeps jamming...

mysql> repair table ftpgroup
->

I've changed database.

 

It will run for some time u need to be patient depending on the size of the table.

 

I waited like 20min and on that table was only 1 row (or how it is called..).

 

You need to include a semicolon at the end of the command:

Code:

repair table <table_name>[B][COLOR="Red"];[/COLOR][/B]

 

Thx! It works now (aka "Why didn't I sort that our by my own.. sigh)