The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql 4.1 -> 5 upgrade ERROR 1017 (HY000)

Discussion in 'General Discussion' started by bmarshallbri, Sep 9, 2006.

  1. bmarshallbri

    bmarshallbri Active Member

    Joined:
    Jan 11, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    I upgraded the mysql database server from 4.1 to 5.0.24 through WHM. Now a lot of my user databases are not working. I can see the schemas and the tables in the schemas in the mysql terminal. But when I try to query a table I get this for eaxmple:

    ERROR 1017 (HY000): Can't find file: 'table_name' (errno: 2)

    Lovely.

    I found another thread from a guy who repaird the mysql schema, which tried to no avail.

    as a test I tried restoring one of the databases from the cpanel backup. It fixed the first one I tried but no love on several others. Plus I'm thinking there has got to be something else going. I'm assuming that something did not quite happen right in the upgrade.

    Can anyone help? Basically I'm totally down as far as my customers are concerned (they're a bit dramatic for a saturday night), but this doesn't quite fit my high availability motto.
     
  2. bmarshallbri

    bmarshallbri Active Member

    Joined:
    Jan 11, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Fixed

    not sure why but when I ran /scripts/mysqlup --force it all came back to life.

    Maybe the second time is the charm!!
     
Loading...

Share This Page