I've searched http://www.mysql.com for information on repairing MySQL tables. All the instructions I found state they are applicable to MySQL version 3.23.xx (I don't remember the last digits) and later. My webhost is running 3.21.33. I have a corrupt table which is interrelated with two others and this has brought down my entire database system. I called my webhost for assistance and they tell me they don't provide support for MySQL....they will delete and re-install the table but that's it. Is there anything I can do to repair this?

Melanie
http://www.somemoorecats.com/ww/
http://www.okhima.org/

Links SQL has an embedded table repair function. If you aren't already using it, you might consider using it.

What is corrupt with your table? You might be able to write SQL commands to manually repair the problems.

Or you could simply dump all tables, then use a SQLDUMP backup (if you have one, which you should) to restore your database.

Regards,

Eliot Lee

I'm sorry...I should have specified which script I'm using. I'm using DBMan SQL and haven't converted to the beta yet but can do so if this would offer a chance of repairing the table. I'm not sure what is corrupt with the table. The error message is that the table handler got error number 127 which, when I look that up, tells me "record-file crashed". Yes, I know I should have a SQLDUMP backup but I don't or at least not one that's very recent. Obviously, I'll be learning from this mistake and correcting that omission in the future. I'll also be looking for a new webhost since I've had nothing but trouble with the MySQL server from day one.

Melanie
http://www.somemoorecats.com/ww/
http://www.okhima.org/