In 3 datafiles it breaks these tables

menu_links
node
system

In 1 of those it also broke

menu_router
nodewords
xmlsitemap

I get - Incorrect key file for table 'system'; try to repair it query:
Repair in phpadmin does not work

Comments

thedosmann’s picture

Title: Upgrade tp Mysql 5 breaks tables » Upgrade to Mysql 5 breaks tables
thedosmann’s picture

Status: Closed (fixed) » Active

I have a backup of datafiles but I cannot revert back to mysql 4.x
command line myisamchk --safe-recover didnt fix
I'm searching for answers if anybody has a direction I would appreciate it.

OK 2 of my Drupal installs I restored the tables from backup and all is well.

With the third Ihave a tremendous amount data that would need to be re built. I am going to try and just restore the bad tables I know I am probably talking to the wind here but if anyone has a suggestion????

Ok all 3 sites are back but I'm having to manuelly create a lot of data on the 3rd site ..oh well.
I am getting the same error inmy quiz module that propted me to upgrade my mysql..

Fatal error: Call to a member function getResponse() on a non-object in /home/p/public_html/sites/all/modules/quiz/question_types/multichoice/multichoice.classes.inc on line 342

But I will open another issue for that. Who knows I might even get a reply.

thedosmann’s picture

Assigned: thedosmann » Unassigned
Status: Active » Closed (fixed)

Status: Active » Closed (fixed)