Replicate a WP install from test site to deployment site

  • Resolved krimsly

    (@krimsly)


    15 years, 7 months ago

    Greetings all.

    I am building a WP site in a test/staging area. Once I’m done, I want to deploy the live site at a different hosting company with a different mySql database instance. It’s important that the settings get preserved. I’m not sure the best way to do this– my idea was:

    * Build a fresh, blank mySql database at the live hosting company.
    * Export the test/staging database and import it into the live blank database.
    * Copy all the WP files from the test/staging area to their final resting place on the live site.
    * Update user name and password in WP config file. Done!

    Will this work, and is there a better way to do this? ??

    Thanks,

    NorthK

Viewing 5 replies - 1 through 5 (of 5 total)

  • sounds like a good plan – that is what I would do (except if url of blog is changing I would change that in the Settings – General 1st and save then do db dump – that way your site will connect correctly)
    might review this just to be sure
    https://codex.www.ads-software.com/Moving_WordPress#Moving_WordPress_to_a_New_Server

    Thread Starter krimsly

    (@krimsly)

    Samboll,

    Thanks a lot for your reply and the link– very useful!

    -NorthK

    Thread Starter krimsly

    (@krimsly)

    All,

    I followed the directions in the Moving WordPress to a New Server link and Samboll’s additions above. Well, it ‘almost’ worked ??

    Everything worked except links to images within posts and pages. It turns out that links to media use absolute paths rather than site-relative paths. So none of the image links worked once I moved the site. I had to go into every post and page and change the link URL’s to point to the new location.

    Does anyone know if there’s a way to tell WP to use site relative links for images and media in posts, rather than absolute links?

    Thanks

    NorthK

    Thread Starter krimsly

    (@krimsly)

    For those of you who run into this problem like I did, here’s a great discussion on it: https://www.ads-software.com/support/topic/159738?replies=19.

    The bottom line is WordPress doesn’t handle the ability to modify URL’s that point to media from within posts and pages when the blog is moved. But there are workarounds.

    I think what I’ll do next time is the search-and-replace method referred to in the discussion above, in the .sql file from the database backup. The .sql file is plain text so you can search for all the media URL’s and replace them with the new ones. Then you restore into the production database using that modified .sql file.

    Still, it would be really, really nice if WP managed this situation for us out of the box ??

    Regards,

    NorthK

    This is a very interesting resource on WP migration

    https://wpgarage.com/tips/6-things-moving-wordpress-blogs-different-host/

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Replicate a WP install from test site to deployment site’ is closed to new replies.