tags:

views:

35

answers:

2

My INNODB database corrupted somehow.I have no backups of that database.

When I click on the database tables in question they come up with: (#1033 - Incorrect information in file: './resafari/properties.frm')

anyone have any solution for that ? please help me.

A: 

Have you recently changed any your configuration through MySQL Administrator?

If so, it is possible that it has commented out all the settings in the my.ini file.

Have a look at this file using a plain text editor, and either manually correct any errors (remove the '#' comment markers) or copy over settings from a backup of my.ini.

HadleyHope
A: 

If the table is really broken (@HadleyHope seems to be on to something that is not down to actual file corruption, check that out first) first of all, stop the mySQL server and make a backup copy of your mySQL data.

Then check out the following SO questions:

Pekka