Totally corrupt mysql database

[pnunn]

I have a totally broken databaes. Mysql just segfaults with any of the asterisk databases in the data directory.

I have run all the tricks I have to repair the tables to no avail.

My only choice is to delete these databases from the data directory and start again with the database.

Is there a way to just rebuild the db’s without blowing away the rest of the phone system configuration or am I hosed and need to just start again?

Thanks.
P.

[hyegeek (Karl Hakimian)]

Assuming you have been doing backups, you should be able to extract the mysql stuff from the backups and rebuild from that. Taking a look at my backup tgz files, I see thing like

mysql-2.sql.gz
mysql-3.sql.gz

That would be where I would start.