Linked Questions

212
votes
27answers
60k views

How to: Easily Move a WordPress Install from Development to Production?

I do development on one box and use a second for production. Right now I just dump the database and then do a find a replace for the URL changes; then copy over the files and import the new SQL. Are ...
42
votes
12answers
43k views

Is there any way to draft a revision of a published page or post? What workarounds have you used?

Say I've already published a page or post. I now want to make changes, but I want a colleague to check them over before they go live. Is there any way of doing this? Edit: I do realise this isn't ...
11
votes
2answers
2k views

Staging sites, how do you manage synchronising updates in the DB?

It is broadly accepted that developers should test updates through a staging site before releasing them to the live server, however once the development updates require modifications in Wordpress DB, ...
1
vote
1answer
4k views

How to Mirror WordPress database from Remote server to Local server

Before I embark on this tutorial from the WordPress Codex on mirroring a WordPress database from a remote server to a local one. I'd like to get some feedback from SE users who have successfully ...
3
votes
2answers
2k views

Syncing production with staging

we have a staging server in order to test out plugins and roll out new features and also re designing sites. The issue is that the staging version of the site will be out of sync as soon as new ...
1
vote
2answers
764 views

Wordpress staging environment that syncs everything except posts?

I've already looked at this question and didn't find it too helpful. We're using Wordpress as a CMS that also includes a blog/news section. The blog/news uses WP "posts" and those are made whenever ...
0
votes
3answers
337 views

How do you keep your live and and testing server?

I have a live site and a testing server (XAMPP) that I built the site on originally before publishing it. Obviously, there are a number of things you need to do to migrate a site from one place to ...
2
votes
1answer
319 views

Deploying Updated or New Plugins That Modify the wp_options Table

I have a WordPress site under local version control with Git. I deploy it to the production server using Capistrano. For the initial deployment, I manually import the SQL database to the production ...
0
votes
0answers
67 views

Is there an actual way to synchronize 'production' and 'develop' WordPress databases?

I work with WordPress and I work with git. My code is versioned and I am happy with the workflow. What bugs me is database synchronization. I need to work with cloned database on my local ...
0
votes
0answers
32 views

Updating Posts table in database without overwriting user generated content

I'm trying to come up with a local development workflow for wordpress that actually works. I'm pretty new to this whole thing but I'm surprised this is so complicated. So far I've been using Git and ...
0
votes
0answers
17 views

Update Pages ONLY from Stage to Live (not products)

I have a WordPress site that has a bunch of posts, a bunch of pages and a bunch of products (Woocommerce ones). I Staged the site and made loads of changes to the pages on stage, meanwhile the live ...