How do you move a Wordpress database?!

Discussion in 'WordPress' started by Pixelrage, Nov 28, 2009.

0
  1. #1
    I've officially given up for the night after fighting for 2 hours to move a Wordpress site from one server/domain name to another...this is what I'm trying to do:

    1) Server A has an existing Wordpress site (a staging server) on a temporary domain name (i.e. "testsite.com")

    2) Server B is where the live Wordpress site will be. It will point to a live domain (i.e. "livesite.com")

    The staging site, "testsite.com" on server A is basically complete. I tried to move the database of "testsite.com" over to a fresh install of Wordpress on server B to "livesite.com", via phpmyadmin and I am getting this error:

    I have absolutely no idea what in hell this is referring to, especially the part about "information_schema". I have literally tried EVERYTHING. I've created a blank database and user on server B, I've deleted the account and started all over again without a blank database, I've tried it all. No matter what I do, I keep getting this error.

    Does anyone know what can be done in this case? I've never seen anything more difficult to do than to move a Wordpress site to another domain name. The help section on Wordpress.org has a simple explanation of how to do it and they make it sound so easy, when in essence, it is FAR from it...
     
    Pixelrage, Nov 28, 2009 IP
  2. Site Reviver

    Site Reviver Peon

    Messages:
    164
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Here you go: jwrmedia.com/how-to/how-to-move-wordpress-to-a-new-server-or-host.html
     
    Site Reviver, Nov 28, 2009 IP
  3. travelmoth

    travelmoth Active Member

    Messages:
    153
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #3
    The error message tell you everything...

    I think the user/pass at server B is different from server A...
     
    travelmoth, Nov 30, 2009 IP
  4. Sweely

    Sweely Well-Known Member

    Messages:
    1,467
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    165
    #4
    This is what I usually do: I go to the tool called PhpMyAdmin and perform a "database backup" - or I just install a wordpress plugin that creates a backup for you, and then I upload to my new server. If you want to, I could help you with moving your SQL database.
     
    Sweely, Nov 30, 2009 IP
  5. myp

    myp Well-Known Member

    Messages:
    1,281
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    140
    #5
    You need to edit your wp-config file on your new server to match the new server's information. You will need to change the prefix based on your new host and how they do it (usually just your login name if it uses cpanel.) You may also need to change the host location because some (Godaddy servers in particular) won't take localhost.
     
    myp, Nov 30, 2009 IP
  6. Networxnz

    Networxnz Active Member

    Messages:
    661
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    63
    #6
    I always appreciate all your replies. More power to you!
     
    Networxnz, Nov 30, 2009 IP
  7. falconeye849

    falconeye849 Active Member

    Messages:
    63
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #7
    Hey,
    Just export the content from the tools->export and download the xml file and import it with tools->import->wordpress then upload the xml file this another method you can do to move the posts,pages,comments,user etc from your exiting site.
    Thanks
    ______________________
     
    falconeye849, Dec 2, 2009 IP