Mysql Error-1033

[naveenkongati]

Hi All,

I am using mysql 5.0. My tables in Database have been corrupted. While checking table status I am getting following error message like ERROR 1033:"Incorrect Information in file:' myform.frm.
Please find the sample table files in attachment.
Kindly tell me how can i resolve this problem.

Thanks in advance
Regards
Naveen

[code green]

Sounds nasty.
Try this link

http://dev.mysql.com/doc/refman/5.1/en/repair.html

[samjoseph74]

Re: MySQL Error

Try to repair your siite using command

REPAIR TABLE tbl_name USE_FRM

[mwasif]

Try to repair your siite using command

REPAIR TABLE tbl_name USE_FRM

This is not going to work.

Actualy table structure file is corrupted, should go to the link provided by code green and look at 'Stage 4: Very difficult repair'.

[melina386]

error 1033

The mysqlcheck -A command shows that all datafiles are affected, except those of the basic mysql database which came along with the installation.
After studying some documentation, I tried mysql_fix_privi lege_tables, which succeeded without complaints, but did not help.
The command mysql_fix_exten sions did not complan, but did not help either.
mysql_convert_t able_format fails with message "Can't convert cat: Error Incorrect information in file: './test/cat.frm' "
With the --force option, it fails on all tables.
Finally I decided to install a MySQL 4.0.x server on another machine, to try to dump the data an structure on this machine and reimport it into the new server.
This machine is running Ubuntu Linux, which installed a MySQL 4.0.23 server. The trouble is that I got the same error messages in that insatllation! Additionnaly, I saw some messages telling something like "No fields found in table blabla"
My conclusion is that it is not an incompatible server version which causes my troubles. But what then ??
I would be really grateful about any hint how to solve this issue.