I just set up a dev.domain.com subdomain and mirror everything there, doing a find/replace on the sql export for www > dev, and of course changing wp-config.
I used to have a staging server I mirrored things on, but I’ve since learned that a change in length of the domain name will invalidate any serialized data that contains it, so I now always keep the staging domain the same length as the live domain.
You could also not sync the comments table so you don’t overwrite interim comments, as long as post IDs don’t change I don’t think this should be an issue.
Related Posts:
- WordPress database synch between dev and prod
- Staging a WordPress site with WP-Deploy
- How to Work Seamlessly Between Development, Staging, and Production Sites in wordpress
- Staging environment for pages only
- Multiple users working on WordPress admin at the same time [closed]
- How to sync staging to production but keep plugin settings
- WordPress Staging Site
- Staging only for Theme Files and Changes
- Staging Sites: What to push through?
- What are some tools for password protecting a staging site?
- Push from staging to live site?
- Staging site offline
- Locked out when attempting a migratoin
- how to move particular functionality to staging server
- Staging/production deployment on WordPress MultiSite
- Where do I build my updated website?
- git add only modified changes and ignore untracked files
- How to: Easily Move a WordPress Install from Development to Production?
- Dev, Stage and Production Deployment for WordPress Sites?
- Database synchronization between dev/staging and production
- DB connection error after copying a WordPress Multisite instance to a second location
- Staging sites, how do you manage synchronising updates in the DB?
- Ways of managing staging and production wordpress sites?
- Migrate Changes from a Staging Site to Production
- Pushing changes from localhost to live server?
- Maintaining synced staging/production WP sites
- Syncing production with staging
- How do you add pages on a staging server, and then move them over to production
- Change management solution for BP-based site?
- How to run a test WordPressMu to WordPress3 update?
- What actions affect files, DB, or both?
- Different color admin bars for dev, staging and production
- Staging Site: Made Public – Security Questions
- Best practice differences in DB options and wp-config between live, staging and local WordPress environments?
- Best Practice for Syncing Local Development With Staging Development [closed]
- Clone plugins (and settings) to new installation?
- Staging sites era: does it still makes sense to develop locally?
- WordPress staging environment that syncs everything except posts?
- Override database config for WordPress multiblog
- Why is my staging subdomain not sending wordpress_logged_in cookies?
- Child theme works in local environment but is not working on remote
- media ‘path’ issue / concern when bringing files live
- Difficulty importing my live site to local
- Create brand-new re-designed site without affecting live site?
- Why is WordPress rewriting absolute URLs on staging site to include staging prefix when we manually point them at the live site?
- htaccess, site and staging in subdirectories
- WordPress & WooCommerce: Localhost, Staging and production environments and how to sync them without losing data
- Published site reverts without changes to theme
- best way to make a WordPresss multisite that is secure but at the same time supporting my plugin development efforts
- Migrating hosts, 500 errors and plugin issues
- Localhost to Staging to Development Dynamic WP-CONFIG
- Setup 3 Sites To Connect To 1 Database and Share Data
- How to run subversion and staging environments when running WordPress
- Controlled publishing in WordPress
- Redirect to another page using contact form 7? [closed]
- Publishing WordPress from stage to production server
- production site routes to staging site after cloning
- Custom links in menus not working in multiple environments
- Clone WordPress site from development server to live server
- WordPress Staging and Testing of Plugins Best Practices
- Google Analytics on a staging site
- How do I change the wpstaging.com domain to new domain without damaging the website?
- Staging redirecting to live site (under construction page)
- How to stage a redesigned site on a new webhost while the original site is still live? [closed]
- What is the correct way to set up a staging server and use github for version control?
- Update Pages ONLY from Stage to Live (not products)
- Merging new theme and plugins from development site to production
- How to fix mime-type and (after disabling nosniff) 404 errors for css and js files in staging site
- Cloning production site down to local?
- WordPress Staging site is redirecting to live and lost the child theme
- Staging Session Randomly Switched from Secure (https) to Not Secure
- Scripts/styles not loading on cloned WP Site when logged in
- Admin Custom Login loses settings on Code and Data migration
- Image paths wrong after migrating with wp-migrate-db-pro media files add-on
- One-way DB Migration Workflow
- Creating a staging area for WordPress.com site
- How to query a staging database?
- Creating WordPress staging environment software
- Migrating site from stage to production server without particular dev. plugins?
- QA/Staging envirnoment for wordpress sites
- Theme/Plugin/Widget Data and Staging/Production Servers
- Graphic design changes on Staging before moving to Production?
- How do I set up a test environment in a sub-folder?
- Imported Posts missing summary text on staging site
- How to set up a development/staging site to make major changes to the theme then update on the live site?
- Is there any other ways to replicating changes on live from staging without pushing from git
- Settings > Permalinks – mod_rewrite ineffective if expression not preceded by /index.php/
- Hide my staging subdomains from search results without impacting the visibility of the root domain