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 problem - new version / old database

Discussion in 'Database Discussions' started by Ben Harrison, Mar 24, 2009.

  1. Ben Harrison

    Ben Harrison Member

    Joined:
    Mar 24, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi all, my host recently upgraded his mysql version and now one of my old sites has cocked up. When i go into the table via phpmyadmin it says..

    Table './lamotte_lamotte/bookings' was created with a different version of MySQL and cannot be read

    Current version is 'MySQL client version: 4.1.22'

    Unsure what the old version is/was.

    I've tried to get my host to sort this as it was something he's done, but he's not willing to help and keeps telling me to come ask on here. He also claims he didn't do any backups before moaving over to this new server with the newer version of mysql. Am I right in thinking this should be his job and not mine?

    Any help - much appreciated!
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    You may need to see if you can have your host copy the raw MySQL files onto a MySQL 4.1 server, then export and import again properly. I don't think you can resolve this any other way that doesn't involve a downgrade.
     
  3. Ben Harrison

    Ben Harrison Member

    Joined:
    Mar 24, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I did ask him to do this and he wouldn't do it :/
     
  4. Kailash1

    Kailash1 Well-Known Member

    Joined:
    Nov 27, 2006
    Messages:
    252
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    I think your host has downgraded the version of MySQL because you should not face the problem if your host upgrade MySQL from previous version.

    MySQL version Downgrade is not supported. It will corrupt all the data if you downgrade the version.

    Kailash
     
  5. Ben Harrison

    Ben Harrison Member

    Joined:
    Mar 24, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Deffinetly upgraded
     
  6. Ben Harrison

    Ben Harrison Member

    Joined:
    Mar 24, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    so is downgrading the only way to go about this?
     
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,448
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Why not try exporting/dumping the DB from shell then reload it to a new DB? Shouldn't hurt anything to try I wouldn't think. How large is the DB?
     
  8. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    Exporting won't work if MySQL can't even read it - downgrading or moving the database to a server with older mysql is the only way to fix.
     
  9. Ben Harrison

    Ben Harrison Member

    Joined:
    Mar 24, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi, recently did an entire account raw backup and the sql file still says 'msql database was created with an older version..' etc. :/
     
Loading...

Share This Page