MySQL DB Migration Question

Discussion in 'MySQL' started by bluemouse2, Aug 4, 2009.

0
  1. #1
    I need to migrate a part of one mysql database to another mysql database. These two have different structures.
    Is there a free tool that can help me achieve this? Thanks.
     
    bluemouse2, Aug 4, 2009 IP
  2. JosephJames

    JosephJames Peon

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If the structures are different, it will be better to write your own migration program so that you know exactly what is going where…
     
    JosephJames, Aug 4, 2009 IP
  3. ilovelinux

    ilovelinux Peon

    Messages:
    285
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You mean the two database servers are not of the same version?
     
    ilovelinux, Aug 4, 2009 IP
  4. bluemouse2

    bluemouse2 Well-Known Member

    Messages:
    4,055
    Likes Received:
    130
    Best Answers:
    0
    Trophy Points:
    185
    #4
    same version
    different structure
     
    bluemouse2, Aug 4, 2009 IP
  5. mioot

    mioot Peon

    Messages:
    169
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    It is best to create your own migration script .
     
    mioot, Aug 4, 2009 IP