servers have diff mysql versions?

Discussion in 'MySQL' started by damnidunno, Sep 20, 2006.

0
  1. #1
    okay this really sucks. I got a new webhost today who seems to be alot better and faster than my older one.

    I used the cpanel backup tool to createa backup of my forums sql database and uploaded it to the new host, but i keep getting weird import errors.

    So finally after hours of trying (im on dial up so it takes over an hour to upload my database) i noticed that my old host uses MySQL version 5.0.24 and my new host uses 4.0.27-standard.

    Is there anyway to get around this?
     
    damnidunno, Sep 20, 2006 IP
  2. onlinedude

    onlinedude Peon

    Messages:
    1,193
    Likes Received:
    322
    Best Answers:
    0
    Trophy Points:
    0
    #2
    When you are exporting the database, you should be able to choose the MySQL Compatibility option and set it to 'MySQL40' in order for the file to be readable by the previous version.
     
    onlinedude, Sep 20, 2006 IP
  3. damnidunno

    damnidunno Well-Known Member

    Messages:
    1,286
    Likes Received:
    22
    Best Answers:
    0
    Trophy Points:
    155
    #3
    yes thank you for that. The new host is great and they told me about all of that and i got the database to import nicely :D
     
    damnidunno, Sep 20, 2006 IP