Merging two databases without borking it

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.

Related Posts:

  1. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  2. Best way to import users, post and categories from an external database
  3. Export WP database for import using WP-CLI on Vagrant Box
  4. MySQL Syntax Error upon restoring database from backup [closed]
  5. Importing New Posts from Live Site into Local Dev Site
  6. Export / import WordPress database
  7. Import users from old WP site to new one
  8. Best practice to import user base (subscribers) from one website to another?
  9. Importer fails to import every post
  10. Is it good practice to import/export a blog to test a redesign?
  11. I broke database after reuploading local version – what exactly happened? Database error
  12. Importing Concrete5 content to WordPress
  13. Why is my database import losing text widget data?
  14. Multiple developers / editors working on a site in progress
  15. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  16. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  17. Solution for database version control and deployment?
  18. How to migrate a HTTPS WordPress installation to localhost?
  19. Migrating data between local and development server
  20. What’s the database relationship between a post and its attachments
  21. Syncing local content with development / staging sites
  22. Organizing WP Pages based on old website database
  23. Importing posts from old website to new conflicting post ID’s?
  24. Exporting revisions
  25. Export wordpress table to excel
  26. When importing database, it shows error
  27. Migrating WP site to another URL
  28. How to migrate a WordPress installation from one site to another, including all images?
  29. How can I export WordPress posts’ attachments?
  30. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  31. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  32. Does WordPress Import/Export tool actually exports media (images) as well?
  33. Is a direct or import approach safer for migration into WordPress?
  34. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  35. Weird issue with database migration and SSL links
  36. How to fix unchanged URLs in Database after running serialized search and replace script?
  37. Migrating database / content of non-CMS site to WordPress
  38. How do I reset a self-hosted WordPress URL?
  39. How much of my site can I recover from public_html?
  40. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  41. Export all content from wordpress
  42. Import live site to local setup without access to live site
  43. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  44. Error establishing a database connection; After importing DB & Theme
  45. Moving minor updates between local and live sites – just database?
  46. Create a clone from one WordPress site to another in a few minutes
  47. How to Mirror WordPress database from Remote server to Local server
  48. Exporting table to csv works in the admin but exports HTML data when used on the front end
  49. How to move the WordPress site Layout from test site to Production site?
  50. How do I migrate blog post images from one domain to a new one?
  51. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  52. How can i customize the export personal data file?
  53. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  54. What is the difference between wp-admin>Export>All content and MySql dump and import
  55. Export + Import = wrongly duplicated content
  56. WordPress Local And Live Site
  57. Copying database tables to new database
  58. Problems with WordPress Import
  59. Migrating from PDO using SQLite to clean new install using MySQL
  60. Migration: Copying database content to a different server
  61. Connection refused on locahost after importing database?
  62. Change WordPress URL in sql file via Terminal
  63. Importing Direct to DB – GUID Question
  64. How to transform a custom made static HTML website to a WordPress website [closed]
  65. Strange characters added to the database
  66. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  67. After database migration, theme mods don’t show [closed]
  68. Problem migrating to localhost
  69. WordPress database products structure
  70. When moving a WordPress installation to a new server, why do I have to update each post before content shows?
  71. How to transfer from localHost to live but use the already existing database on the server?
  72. Image link issues after importing a database backup to my local web server
  73. Database migration issues – Error #1046 No database selected
  74. product export and import using xml
  75. echo site_url() returns a different value than what is in the database siteurl field
  76. How do you do your big exports / imports?
  77. Bulk Edit Media Library alt, caption, image names
  78. Migrate Users From laravel to wordpress
  79. /wp-admin not accessible after migrating to local host (no plugin issue)
  80. How to fix Uploaded to this post option to see group of images uploaded to a post?
  81. How do you enable scripts on a WordPress installation in Softaculous?
  82. WordPress site migration – locked out of admin area
  83. Malware in old website – how to migrate?
  84. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  85. Export only a part of the database for migration
  86. Exporting Post type from one theme and importing it to another theme
  87. WP website showing blank page after moving from subdomain to main domain
  88. WordPress Migration – Issue with admin panel changes
  89. How to edit posts/pages without making the change live?
  90. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  91. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  92. Restoring .sql backup results in “Error establishing a database connection”
  93. Migrate bbpress content to posts
  94. import (migration) user database to wp-users
  95. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  96. Moving database from WP 2.6 to 3.5 problem
  97. export individual posts to text files or a single csv file
  98. Saving data to database and exporting to excel
  99. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  100. Does WordPress import export tool keeps the file hosted on the old website?