How can I repair a crashed table?

[southbeach]

Howdy!

Using Asterisk on Ubunto Linux and just ran into a problem. My HD ran out of space (found the trouble log file). I recovered my space but now, MySQL is freaking out.

I found that at least one table is marked as corrupted (asteriskcdrdb/cdr) and, of course, I need to repair it.

How can I repair this table?

Thank you all in advance!


--
SouthBeach
The good thing about not knowing is the opportunity to learn - Yours truly, 2008.

 

[ingresman]

I've never done this but have a look at

http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

and see how far you get.
Hopefully someone will be by soon who's done it before.
also do you have a support contract with mysql, if so get them on the case

 

[southbeach]

ingresman,

Thanks for replying. I found a number of commands and compiled them ... here they are:

To connect to your MySQL Server:
# mysql -u root -p password

To display your databases:
mysql> show databases;

To display a list of tables:
mysql> show tables;

To repair a crashed table;
mysql> repair table [tablename];


Now, from the command prompt, if you wanted to check/repair all tables within a database:

# mysqlcheck -r -u username -p password databasename

or

# myisamchk -r -u root -p password databasename

Regards,


--
SouthBeach
The good thing about not knowing is the opportunity to learn - Yours truly, 2008.

 

[ingresman]

so have you repaired it then ?

 

[southbeach]

Yes, I have.

I had to go back and key in some data that evidently was lost in the process. In this case, the data was related to voicemail configuration for my various defined extensions.

Thanks!


--
SouthBeach
The good thing about not knowing is the opportunity to learn - Yours truly, 2008.