Moving to a new hosting- How can I backup my databases

Discussion in 'MySQL' started by Nima, Jul 17, 2007.

0
  1. #1
    Im moving to a new hosting company...

    I am trying to backup my databases at the current hosting and then transfer them to the new one....

    How do I exactly do that?

    Do I just go to phpMyAdmin and click "Export" and export everything?

    Thanks
     
    Nima, Jul 17, 2007 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    More or less.

    Make sure you know which mysql version your new host uses, 4.xx is the most common. Save the exports in utf format. Make more than one backup just in case.

    Also make sure you know the IP your current account is on in case you need to get back there after the dns resolves.
     
    Colbyt, Jul 17, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    you can also backup db's with mysqldump via ssh.
     
    gibex, Jul 17, 2007 IP
  4. Nima

    Nima Well-Known Member

    Messages:
    3,489
    Likes Received:
    243
    Best Answers:
    0
    Trophy Points:
    175
    #4
    thank you guys
     
    Nima, Jul 17, 2007 IP
  5. login

    login Notable Member

    Messages:
    8,849
    Likes Received:
    349
    Best Answers:
    0
    Trophy Points:
    280
    #5
    If you have cPanel you can easily back it up from there too.
     
    login, Jul 17, 2007 IP
  6. RNelson

    RNelson Active Member

    Messages:
    864
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #6
    If there both cPanel servers I will download the database and reupload it back up for you free ;]
     
    RNelson, Jul 17, 2007 IP
  7. uniqueasitis

    uniqueasitis Peon

    Messages:
    661
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Yes the best way to go is to download the database and then re upload it on the other website. It is easy. I think you already know what you are doing
     
    uniqueasitis, Jul 17, 2007 IP