4

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
  • 2
    The short answer here is no. Delicious Brains was working on a solution for this called Mergebot and gave up after dumping time and money into it for 2 years.
    – mrben522
    Mar 12, 2019 at 18:36

1 Answer 1

0

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.

2
  • That doesn't seem to even remotely address the question.
    – Patrick
    Mar 13, 2019 at 2:06
  • It's a possibility to migrate changes from one database to another. @Patrick Mar 13, 2019 at 4:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.