Jump to content


Photo

Database Table Error


  • Please log in to reply
6 replies to this topic

#1 mcmuney

mcmuney
  • Members
  • PipPipPip
  • Advanced Member
  • 358 posts

Posted 01 September 2006 - 05:50 AM

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???

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 01 September 2006 - 02:13 PM

Run CHECK TABLES, see what it says.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 mcmuney

mcmuney
  • Members
  • PipPipPip
  • Advanced Member
  • 358 posts

Posted 01 September 2006 - 05:12 PM

When I run check or repair, it shows okay as the status, but completely excludes the bad table.

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 01 September 2006 - 05:41 PM

Excludes how?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 mcmuney

mcmuney
  • Members
  • PipPipPip
  • Advanced Member
  • 358 posts

Posted 01 September 2006 - 06:26 PM

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?

#6 mcmuney

mcmuney
  • Members
  • PipPipPip
  • Advanced Member
  • 358 posts

Posted 01 September 2006 - 09:24 PM

If I request the .frm files from my host server, will I be able to recover data from that file?

#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 02 September 2006 - 03:48 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users