Need Db Downgraded to version 4.0

Discussion in 'MySQL' started by harjitgill, Sep 11, 2006.

0
  1. #1
    Hello,

    I have come across a problem regarding MySQL database versions. I have a MySQL version 4.1.15 database, but I am in the process of changing hosts and the new host has MySQL 4.0.0 installed. The hosting company said they can't upgrade right now. I really need this db up.

    If anyone can help or do this. Please reply.

    Thanks,
    Harjit
     
    harjitgill, Sep 11, 2006 IP
  2. BIGC

    BIGC Peon

    Messages:
    612
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #2
    The same BD works on Both the servers ..give a try
     
    BIGC, Sep 11, 2006 IP
  3. koolasia

    koolasia Banned

    Messages:
    1,413
    Likes Received:
    59
    Best Answers:
    0
    Trophy Points:
    0
    #3
    well i m not sure abt this
     
    koolasia, Sep 11, 2006 IP
  4. harjitgill

    harjitgill Active Member

    Messages:
    141
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #4
    it doesn't work it has to be downgraded.
     
    harjitgill, Sep 11, 2006 IP
  5. bochgoch

    bochgoch Peon

    Messages:
    1,918
    Likes Received:
    67
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The exact answer depends on what tools your are using.

    Easiest solution is to simply export to text file (DDL + INSERT statements) data and structures then reimport them into the new database.

    Please provide further details of your toolset. I personally use SQLyog which provides this functionality quickly and easily. Are you using phpMyAdmin on the server?

    bg
     
    bochgoch, Sep 12, 2006 IP
  6. harjitgill

    harjitgill Active Member

    Messages:
    141
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #6
    iam using phpmyadmin to transfer between hosts. It is version 2.4 on the host iam exporting from. If anyone has version 2.6 please help me out, I will sent the .sql file and u can convert it to version 4.0

    Thanks
     
    harjitgill, Sep 13, 2006 IP