How to move databases from one server to another

Discussion in 'MySQL' started by iowadawg, Sep 22, 2006.

  1. #1
    Okay, got another hosting account and have to move some sites.
    The site files themselves are no problem for me to move.
    It is the mysql databases that have me stumped!

    How do I also move them?
    Or will it work to download the files to my computer and then re-upload?

    Thank you.
     
    iowadawg, Sep 22, 2006 IP
  2. runnerunner

    runnerunner Active Member

    Messages:
    1,027
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    90
    #2
    how big are the databases? I've always exported the databases to a txt file, then just dumped them into the new database, but maybe mine weren't all that big?
     
    runnerunner, Sep 22, 2006 IP
  3. iowadawg

    iowadawg Prominent Member

    Messages:
    10,918
    Likes Received:
    811
    Best Answers:
    0
    Trophy Points:
    380
    #3
    I have to go to phpadmin and copy everything as txt file?

    Will try, no great rush yet on moving the sites as have to wait for the new host to do whatever they do to get things running.
     
    iowadawg, Sep 22, 2006 IP
  4. Forum-Angels

    Forum-Angels Peon

    Messages:
    469
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    0
    #4
    doesnt your host give you a option in your cpanel or what ever your using to back up your databases?

    also you can use phpmyadmin to back up the databses, and you dont have to do everything hand by hand
     
    Forum-Angels, Sep 22, 2006 IP
  5. SLiM_BoY

    SLiM_BoY Peon

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hmm, you can find some dump scripts to backup your databases..Also you can dump it to your new host..
     
    SLiM_BoY, Sep 22, 2006 IP
  6. iowadawg

    iowadawg Prominent Member

    Messages:
    10,918
    Likes Received:
    811
    Best Answers:
    0
    Trophy Points:
    380
    #6
    Okay, I should have taken that first SIMPLE step!
    Ask my host company!

    They will move the databases for me when I am ready.
     
    iowadawg, Sep 22, 2006 IP