Moving database from 2 webhosts

Discussion in 'MySQL' started by Postaldude, Oct 22, 2007.

0
  1. #1
    Is it possible to move my entire website from, 1 host to another? i want the exact settings and everything on the new host. Is it possible to move my entire folder into the new host and its database making the site function just like how it use to?

    complete noob, ready to change webhosts
     
    Postaldude, Oct 22, 2007 IP
  2. tonybogs

    tonybogs Peon

    Messages:
    462
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It is possible but not a very desirable job :)

    For the file system you can use rsync or rdiff. Or simply tar up the files and ftp them to your new server then extract it.

    For your database, if it isnt big you can grab an sql dump and just import that on your new server. Another option might be to set your current database as a master and create a slave on the new one, then replicate over.

    Id love to go into more detail for you but it can be a tedious task :(

    Good Luck with it :)
     
    tonybogs, Oct 23, 2007 IP
  3. Postaldude

    Postaldude Peon

    Messages:
    170
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    is this not a really common thing to do? ive been wondering how to do it for so long now!
     
    Postaldude, Oct 23, 2007 IP
  4. xdynamite

    xdynamite Banned

    Messages:
    94
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    its very hard man im doing mine now causing me all sorts of mysql errors
     
    xdynamite, Oct 23, 2007 IP
  5. tandac

    tandac Active Member

    Messages:
    337
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #5
    I did two or three of these last week for different clients It's really not that hard, provided you have the right tools.

    mysqldump, tar and a good ssh connection are all you really need.

    Feel free to PM me if you want help.
     
    tandac, Oct 24, 2007 IP
  6. st1905

    st1905 Well-Known Member

    Messages:
    573
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    135
    #6
    It is not that hard, in fact it is extremely easy if you want to make it yourself then you`ve to serach for some info on the web or pay someone to do it for you.
     
    st1905, Oct 25, 2007 IP
  7. weeder

    weeder Peon

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Its easy i have done it many times
    All i have used is bigdump and a few file edits may also be necessary
     
    weeder, Oct 25, 2007 IP
  8. Postaldude

    Postaldude Peon

    Messages:
    170
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    bigdump's instructions arent too clear to me. :*( but ill give it a try.
     
    Postaldude, Oct 31, 2007 IP
  9. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #9
    Bigdump is used to run multiple queries which would otherwise time out.
    It helps in importing large databases easily. To use bigdump, copy
    the bigdump files and your sql statements in to a folder on the server
    and run bigdump.
     
    Kuldeep1952, Oct 31, 2007 IP
  10. Sebastian Rametta

    Sebastian Rametta Peon

    Messages:
    13
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #10
    I have done this many times over. Is this just a plain dedicated server with apache/mysql/php/perl? or is there some sort of control panel on it. If there is a control panel, it makes things much easier, if its a plain vanilla box it could take a few hours to get right as you have to ensure your apache/php/perl are compatible with your scripts. As well, I would try and move to the same version of mysql if you can.

    I'd love to give some instructions but there are so many variables and situations that I have experienced it would be difficult to summarize it down. If you have any specific questions post them and I'll answer as concise as i can.

    - Sebastian Rametta
     
    Sebastian Rametta, Nov 4, 2007 IP