Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysql problem - new version / old database

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

  1. Ben Harrison

    Ben Harrison Member

    Joined:
    Mar 24, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    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:
    829
    Likes Received:
    26
    Trophy Points:
    178
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Ben Harrison

    Ben Harrison Member

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

    Kailash1 Well-Known Member

    Joined:
    Nov 27, 2006
    Messages:
    253
    Likes Received:
    2
    Trophy Points:
    168
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Ben Harrison

    Ben Harrison Member

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

    Ben Harrison Member

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

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,163
    Likes Received:
    370
    Trophy Points:
    583
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    829
    Likes Received:
    26
    Trophy Points:
    178
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. Ben Harrison

    Ben Harrison Member

    Joined:
    Mar 24, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice