MYSQL issue after update

  • 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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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.

    Thread Starter scarlettroad

    (@scarlettroad)

    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?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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?

    Thread Starter scarlettroad

    (@scarlettroad)

    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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘MYSQL issue after update’ is closed to new replies.