WordPress.org

1. scarlettroad
   Member
   Posted 10 months ago #

   I had to update my mysql in order to upgrade to WP 3.2. I have a multi site setup. Now, nothing loads.

   When i go into mysql admin, it tells me that wp_blogs is corupt and empty. I backed up the database before upgrading but it wont even load. here is what I am getting... HELP!

   WP_BLOGS is in_use

   when trying to repair i get
   db3885_wp4srindex_new.wp_blogs repair Error Incorrect key file for table 'wp_blogs'; try to re...
   db3885_wp4srindex_new.wp_blogs repair error Corrupt

   When i load the table i get
   Error
   SQL query:

   SHOW INDEX FROM wp_blogs ;

   MySQL said:

   #1034 - Incorrect key file for table 'wp_blogs'; try to repair it

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 10 months ago #

   Upgrading SQL is NOT a non-trivial thing. What version of SQL did you come from?

   IIRC you can't upgrade from 4 to 5, you have to install 5 and then export/import your DB to the new SQL.

3. scarlettroad
   Member
   Posted 10 months ago #

   I moved from 4. something.

   I tried to import the DB but the same error comes up that that one table is fried. Is there anyway to write it manually or some other fix?

4. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 10 months ago #

   There may be, but SQL upgrades from 4 to 5 is when I go hire someone to do it for me :/

   Do you have a GOOD backup of your DB?

5. scarlettroad
   Member
   Posted 10 months ago #

   No. I did 3 backups and they all are not working. My host did the update so I did not think there would be an issue.

6. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 10 months ago #

   If they did the upgrade for you, I would get on the phone with them and tell them it didn't work.

Reply

You must log in to post.