Moving WP install and DB

  • I am trying to move WordPress and DB to a new server with a new domain name. I’ve been trying this for weeks, so before proceeding this time I want to ask the community’s input. Here’s what I think I should do:

    1. Back up existing database on https://www.serverOne.com.
    2. Import this database, via PHPmyAdmin, to https://www.serverTwo.com
    3. Copy WP files to my computer.
    4. Upload WP files to serverTwo.com.
    5. Edit wp-config to reflect new URL.

    Am I missing something? Since I am importing the existing DB, will the DB name and password info in my wp-config need to be changed?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    See this article.

    https://codex.www.ads-software.com/Moving_WordPress#When_Your_Domain_Name_or_URLs_Change

    2. Import this database, via PHPmyAdmin, to https://www.serverTwo.com

    On www.serverTwo.com use a search and replace tool to modify all the URL references from https://www.serverOne.com to https://www.serverTwo.com.

    This one works really well on the new server, as it also takes care of the serialized PHP strings too. Just remember to delete it when you are done.

    https://interconnectit.com/124/search-and-replace-for-wordpress-databases/

    Thread Starter OpenEars

    (@openears)

    Whew! Thank you, but maybe I can back up a little to explain:

    I have resorted to trying to import my existing DB because I am unable to install WordPress on the new server in the first place: I have edited the wp-config file with the DB name, username, and password (which were created for me), but when I go to the URL of the ‘vanilla’ install, I get an ERROR 500 message. If I go to the admin address I get a 403 Forbidden message. I suspect something is incorrect with the DB that was set up, and thought I could side-step this by importing the DB and the existing WP files all at once. Does this make any sense at all?

    On this server, I do not have permissions to create a new DB, even though I have access to phpMYadmin…

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    I am unable to install WordPress on the new server in the first place

    Ah. Well yes, then those other steps wouldn’t work. ??

    On www.serverTwo.com get a plain, fresh and empty installation on WordPress first. An installation with no plugins or new theme shouldn’t toss any 500 errors.

    On this server, I do not have permissions to create a new DB, even though I have access to phpMYadmin…

    You should be able to import the .sql file backup into the new DB without changing it’s name. You may need to speak with your host and ask them what’s going on.

    If that doesn’t work and www.serverOne.com is still online then try exporting to WXR and import that file into WordPress on www.serverTwo.com. Assuming you can get WordPress running there…

    Thread Starter OpenEars

    (@openears)

    Thank you so much! I will try importing the DB (following your advice above). It has been weeks of headaches, so if I still can’t get an empty WordPress install on serverTwo.com, then I’ll get in touch with the admin here and (sigh) ask him to help out.
    Thank you!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Moving WP install and DB’ is closed to new replies.