Note: This is more a comment than an answer, but I wanted to format it nicely. I don’t know about recording, but I imagine something like the following in SQL could work. INSERT INTO DB1.Tbl1 ( id, x, y ) SELECT DB2.Tbl1.id, DB2.Tbl1.x, DB2.Tbl1.y FROM DB2.Tbl1 ON DUPLICATE KEY UPDATE x=x, y=y; Beware, this is … Read more
The problem seems to be you not deciding what is the “staging” server for. If it is for content staging/creation than it is actually a production server from software development POV. Anything that assumes that the software is functioning well and results in something being actually published is part of the production system. You need … Read more
Newer hosting providers that cater specifically to WordPress usually have tools in place to ease this pain. I put my clients on Pantheon which has this neat Git-enabled workflow, where code only moves up (from dev to staging to production) and DB stuff only moves down (vice versa from the code). Copying a database from … Read more
One thought – when I go to www.example.com/staging/wp-admin it automatically redirects me to www.example.com/wp-admin Could the redirect from staging.example.com to example.com/staging be conflicting with the existing install? UPDATE: looks like it could be related to .htaccess issues and complicated domain references in the database From the WP Codex: Moving WordPress Multisite Multisite is far more … Read more
The reality is that what we want is this: http://www.liquibase.org/ Liquibase is an open source (Apache 2.0 Licensed), database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes are stored in a human readable yet trackable form and checked into source control. However our development process … Read more
There may be a better way that I am missing but I am going to give you 2 options: 1.Use XML Export to export your new posts and comments. Then use the WordPress Importer to import the new posts and comments back into the dev database It’s best to import into dev then move the … Read more
I have a setup I’m pretty proud of, and it works extremely well for my team. General Structure I keep the entire installation under git. All changes, be it a system update, adding/updating a plugin, adding/updating a theme, go through the same workflow. Changes can be rolled back at a moment’s notice. I have a … Read more
@Insanity5902: Deployment of a WordPress site from one box to another has been a PITA since day one I started working with WordPress. (Truth-be-told it was a PITA with Drupal for 2 years before I started with WordPress so the problem is certainly not exclusively with WordPress.) It bothered me that every time I needed … Read more
Ideally your .gitignore should prevent the untracked (and ignored) files from being shown in status, added using git add etc. So I would ask you to correct your .gitignore You can do git add -u so that it will stage the modified and deleted files. You can also do git commit -a to commit only the modified and deleted files. Note that if you … Read more