最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

migration - Merging two databases without borking it

programmeradmin1浏览0评论

Does anyone have a solution to the following issue:

I have a staging and production server. We've done work on staging but things have been changed on production so we can't just move the DB from ST->PR. Is there a plugin or some other solution that looks at all singular items and updates/overwrites that post only if the post is newer as a revision on production?

Does anyone have a solution to the following issue:

I have a staging and production server. We've done work on staging but things have been changed on production so we can't just move the DB from ST->PR. Is there a plugin or some other solution that looks at all singular items and updates/overwrites that post only if the post is newer as a revision on production?

Share Improve this question asked Oct 31, 2019 at 11:25 mancmanc 2131 gold badge3 silver badges10 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 0

This is a notoriously difficult thing to solve in WordPress because of how the database is constructed. I have since long given up on being able to merge dev -> staging -> prod.

Instead, I track any and all changes I make to the database in my dev environment, manually apply those to the production database when that time comes.

I know it's not a nice answer, but it's the only one you'll get when you need assurances that the DB won't be borked.

发布评论

评论列表(0)

  1. 暂无评论