Changing hosts! Migrating db?

Discussion in 'MySQL' started by epot, Nov 2, 2006.

  1. #1
    Hello I am new to DP and have a question.
    I am changing hosts and have to migrate mysql to new host. The new mysql is 4.0 and the old one is 3.23. Will this be a problem?
    thx
     
    epot, Nov 2, 2006 IP
  2. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Depends on your queries and your structures. Going up is easiert han going down so it should be OK. Give it a test in a beta environment first.
     
    T0PS3O, Nov 2, 2006 IP
  3. epot

    epot Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thx for the quick reply. site is directory script, not sure if that makes a difference? I am still in the process of learning mysql.
     
    epot, Nov 2, 2006 IP
  4. subseo

    subseo Guest

    Messages:
    652
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Just try it, there is no other way. I had migrated directory scripts, encountered problems once or twice, mostly it was solved by just changing some little details in the database dump.
     
    subseo, Nov 2, 2006 IP
  5. Pat Gael

    Pat Gael Banned

    Messages:
    1,331
    Likes Received:
    68
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Basically the problem you will face is trying to dump your data via phpMyAdmin with all its new annoyances.

    Otherwise must not be a problem at all
     
    Pat Gael, Nov 2, 2006 IP
  6. thedark

    thedark Well-Known Member

    Messages:
    1,346
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    168
    Digital Goods:
    1
    #6
    if the mysql where you want to move your database is higher than the old one, you will not receive any errors.
     
    thedark, Nov 2, 2006 IP
  7. homebizdev

    homebizdev Peon

    Messages:
    52
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    You should ALWAYS test out something new before going live with it.
     
    homebizdev, Nov 16, 2006 IP