How To Upload Saved Wordpress Database to New Host

Discussion in 'WordPress' started by wordpressgal, Dec 1, 2007.

0
  1. #1
    I am hosting my Wordpress blog in Host A.

    I want to transfer all Content, Feedback and Comments of this Blog to Host B.

    I used cPanel > MySQL > phpMyAdmin to Save 3 Database already into Notepad.

    How do I Transfer / Upload these 3 Database into the Same Domain but to a different host, please?:)
     
    wordpressgal, Dec 1, 2007 IP
  2. lateuk

    lateuk Active Member

    Messages:
    317
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #2
    If you can run a command prompt vis ssh or telnet on you new host, i would advise uploading the database via ftp then using the following command to install the database:

    mysql -u <username> -p<password> <databasename> < <fileneame>

    Without the <>

    Late
     
    lateuk, Dec 2, 2007 IP
  3. MISsupport

    MISsupport Peon

    Messages:
    269
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If it's not too late, in WP:
    Host A:
    Manage - Export

    Host B:
    Manage - Import

    Should be simpler
     
    MISsupport, Dec 2, 2007 IP
  4. Kerosene

    Kerosene Alpha & Omega™ Staff

    Messages:
    11,366
    Likes Received:
    575
    Best Answers:
    4
    Trophy Points:
    385
    #4
    Another "if it's not too late" suggestion:

    Why not just create a cPanel backup of the site/db, and have your new host migrate your entire site over?
     
    Kerosene, Dec 2, 2007 IP