Corrupt MySQL Database

[montvil3]

Hi,

I have a corrupt MySQL database. Is there anyway I can fix this without starting over? I tried running REPAIR TABLE alldata to repair the table, but that did not work. The message tells me that the table is in an incorrect file format and that my table is corrupt. The data are not all that important, but I'd like to figure out how to fix the table if I can. If there are any other ways to try and repair the table, that would be greatly appreciated.

Thanks,
Chris

 

[Anna]

Unfortunately if you do not have a backup of your own to restore there is currently no option but to start over.

The only backups we have are to restore the entire server in case of failure and not feasible to extract one database from easily.

 

[montvil3]

Alright. Thanks. That's what I figured. The data aren't that important, so it's no big deal having to start from scratch. I'll make sure to do regular backups of my table in future.