WARNING: mysqlcheck has found corrupt tables

[nakeman]

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.

[topdog]

You need to repair the corrupt tables.

[nakeman]

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

[topdog]

you do that for myisam tables from the mysql prompt

mysql> repair table <table_name>

[nakeman]

Why it keeps jamming...

mysql> repair table ftpgroup
->

I've changed database.

[topdog]

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

[nakeman]

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

[falko]

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

repair table <table_name>;

[nakeman]

Originally Posted by falko

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

repair table <table_name>;

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