mysql5 problem

Discussion in 'MySQL' started by niessuh, May 26, 2008.

0
  1. #1
    my current host is using mysql5 so all of my database were on mysql5.. and i will transfer on a hosting which supports only mysql 4.. can i import it or not? if not, what should i do?
     
    niessuh, May 26, 2008 IP
  2. j-a-m-z

    j-a-m-z Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I have been doing some research for you, some say it should work, some say it shouldn't work, but from experience, the best thing to do is to just try importing it, If it dosen't work nothing will you happen.

    James.
     
    j-a-m-z, May 26, 2008 IP
  3. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #3
    While exporting the data, use the Option "SQL compatibility mode"
    to export with Mysql 4 compatibility.
     
    Kuldeep1952, May 26, 2008 IP