mcmuney Posted September 1, 2006 Share Posted September 1, 2006 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??? Link to comment https://forums.phpfreaks.com/topic/19323-database-table-error/ Share on other sites More sharing options...
fenway Posted September 1, 2006 Share Posted September 1, 2006 Run CHECK TABLES, see what it says. Link to comment https://forums.phpfreaks.com/topic/19323-database-table-error/#findComment-84038 Share on other sites More sharing options...
mcmuney Posted September 1, 2006 Author Share Posted September 1, 2006 When I run check or repair, it shows okay as the status, but completely excludes the bad table. Link to comment https://forums.phpfreaks.com/topic/19323-database-table-error/#findComment-84140 Share on other sites More sharing options...
fenway Posted September 1, 2006 Share Posted September 1, 2006 Excludes how? Link to comment https://forums.phpfreaks.com/topic/19323-database-table-error/#findComment-84157 Share on other sites More sharing options...
mcmuney Posted September 1, 2006 Author Share Posted September 1, 2006 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 ok3 ok5 okIt won't even show 2 and 4 as being bad. What are my options as far is data retreival? Link to comment https://forums.phpfreaks.com/topic/19323-database-table-error/#findComment-84184 Share on other sites More sharing options...
mcmuney Posted September 1, 2006 Author Share Posted September 1, 2006 If I request the .frm files from my host server, will I be able to recover data from that file? Link to comment https://forums.phpfreaks.com/topic/19323-database-table-error/#findComment-84279 Share on other sites More sharing options...
fenway Posted September 2, 2006 Share Posted September 2, 2006 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. Link to comment https://forums.phpfreaks.com/topic/19323-database-table-error/#findComment-84612 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.