By Patrick


2019-03-08 19:48:28 8 Comments

Is there a tool that allows me to "record" changes to a staging site and later replay them on production?

It is a common usecase for me to set up a staging site (Duplicator is great for that) and implement design changes (including menus, etc.) there for the customer to review. Those changes at some point need to go to production. Works well with files (plugins, themes), but not with the database.

The production system is being used all the time and authors will add content while I'm working on the staging site. Hence I can't simply copy over the whole posts table.

Instead I'd need a solution that records any SQL statement made to selected tables and replays them on production later on. Is there such a solution out there?

1 comments

@Nicolai 2019-03-12 18:21:13

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 completely untested. You have to test it and read up on the documentation yourself.

@Patrick 2019-03-13 02:06:06

That doesn't seem to even remotely address the question.

@Nicolai 2019-03-13 04:13:44

It's a possibility to migrate changes from one database to another. @Patrick

Related Questions

Sponsored Content

3 Answered Questions

[SOLVED] Multiple developers / editors working on a site in progress

2 Answered Questions

Syncing production with staging

2 Answered Questions

Wordpress Staging Site

1 Answered Questions

[SOLVED] One-way DB Migration Workflow

2 Answered Questions

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

4 Answered Questions

2 Answered Questions

[SOLVED] switching test to production > main menu forgotten, background forgotten

  • 2013-05-29 08:32:54
  • Berry Tsakala
  • 52 View
  • 0 Score
  • 2 Answer
  • Tags:   menus migration

3 Answered Questions

[SOLVED] Maintaining synced staging/production WP sites

2 Answered Questions

[SOLVED] Graphic design changes on Staging before moving to Production?

Sponsored Content