Jump to content

Archived

This topic is now archived and is closed to further replies.

mcmuney

Database Table Error

Recommended Posts

I'm getting this error, "#1033 - Incorrect information in file: './rateomet_script/sc_member_images.frm' " when logging into myphpAdmin and as a result, this table cannot be accessed. I've reported the issue to my shared host tech support, they just upgraded their server and seem to be clueless. Meanwhile, my site isn't pulling any data and last backup is a month old. Any guru's know how to export in the above situation without having back-end access???

Share this post


Link to post
Share on other sites
Run CHECK TABLES, see what it says.

Share this post


Link to post
Share on other sites
When I run check or repair, it shows okay as the status, but completely excludes the bad table.

Share this post


Link to post
Share on other sites
Just won't display. For example, lets say i have 5 tables, of which, 2 and 4 are the errors. During check/repair, it will show like this:

1 ok
3 ok
5 ok

It won't even show 2 and 4 as being bad. What are my options as far is data retreival?

Share this post


Link to post
Share on other sites
If I request the .frm files from my host server, will I be able to recover data from that file?

Share this post


Link to post
Share on other sites
No -- the FRM file is just the table definition, and related meta-data.  But assuming you have a backup of the MYD/MYI files, you can probably make a "new" table with the exact same definitions, copy the new FRM file, and rename it accordingly.  It's worth a shot.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.