Database synchronization between dev/staging and production

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 database over to production because when you import it will download all the new media files from production.

In the meantime production has changed(new posts, new comments, etc.)

This would solve your problem of bringing in any changed content.

2. Use the INSERT IGNORE INTO MySql command to add the new tables from dev. or the REPLACE command to overwrite duplicate rows in the same table.

Before using MySql make a backup of both databases and move the gz database to the production server and upload the dump (change the name of dev if it’s the same as production.

INSERT IGNORE INTO `_wp_production_db`.`wp_cool_plugin_options`
SELECT *
FROM `_wp_dev_db`.`wp_cool_plugin_options`

I’m not comfortable with MySql commands so I would go with option 1.

Related Posts:

  1. What actions affect files, DB, or both?
  2. Ways of managing staging and production wordpress sites?
  3. Merging WordPress posts from different databases
  4. Localhost to Staging to Development Dynamic WP-CONFIG
  5. Setup 3 Sites To Connect To 1 Database and Share Data
  6. How to: Easily Move a WordPress Install from Development to Production?
  7. MySQL Database User: Which Privileges are needed?
  8. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  9. Safest way to bulk delete post revisions
  10. Staging sites, how do you manage synchronising updates in the DB?
  11. How can I make a WordPress database portable and url independent?
  12. Why does $wpdb return strings for mysql integer values?
  13. Dealing with Many Meta Values, 30+
  14. When is it appropriate to create a new table in the WordPress database?
  15. Is it possible to switch the data layer within WordPress?
  16. store simple data in get_option()
  17. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  18. Have multiple local wordpress installs share a wp-content folder and database
  19. Maintaining synced staging/production WP sites
  20. How do you add pages on a staging server, and then move them over to production
  21. How to implement content from external database into WordPress text page? [closed]
  22. Cloning and syncing a WordPress website
  23. Add search Value to wp_list_table pagination
  24. How to fix unchanged URLs in Database after running serialized search and replace script?
  25. Should non-WordPress data get its own DB?
  26. Who is responsible for data sanitization in WordPress development?
  27. Search and replace special characters (å,ä,ö) for image attachments only in database
  28. Difficulty importing my live site to local
  29. WordPress Staging Site
  30. Uknown meta entries in wp_postmeta
  31. Changing between Local Host DB to Production DB and in reverse
  32. creating new field on mysql
  33. Why user_pass column in wp_users table is varchar(64)
  34. Can local WordPress installs share /wp-content/ folder and database?
  35. SymmetricDS in dev + prod workflow?
  36. Database migration issues – Error #1046 No database selected
  37. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  38. WPCLI search and replace in a particlar site dir effect another site-dir
  39. Merging development site with live site
  40. One WP Database outside localhost and two connections
  41. Get id from database
  42. Share WordPress Database
  43. MySQL Database User: Which Privileges are needed?
  44. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  45. How many users can WordPress handle?
  46. Automate WordPress Database Upgrade
  47. WordPress database scalability from the code perspective
  48. WordPress Unit Testing – Cannot Create Tables
  49. how do I determine which image is the featured image in the database
  50. Why does dbDelta() not catch MysqlErrors?
  51. how to transfer wordpress sql/database from local to live
  52. Is altering a default WordPress database table update safe?
  53. what to do when your WordPress database is too large?
  54. Change all http to https in mysql databse?
  55. WordPress DB: options-table –> 32 gzipcompression?
  56. Having issues with wp_postmeta and wp_usermeta tables too big
  57. How to prevent WordPress from retrieving data for the last 10 posts in the database?
  58. Uppercase to sentence case for post titles
  59. How to retrieve and show database table in wordpress dashboard
  60. Moving to another host; which tables to move in a database
  61. How can I transition a site from using the Beta Tester plugin to a “normal” install?
  62. Storing data for a wordpress plugin
  63. Why do mass updates to post_content shows in front end, but not in edit screen?
  64. Insert post in another database
  65. Redirecting to old domain after migration website
  66. Localhost keeps redirecting to live domain
  67. How to get membershiplevel from WordPress Database?
  68. Child parent relationship inside WP DB
  69. Copying database tables to new database
  70. Duplicating Complete WordPress Install for Development and then Redeployment?
  71. What does wp_term_taxonomy.parent reference?
  72. How to combine multiple wp_insert_post into one in order to gain better performance
  73. Two prefixes in database? Which one is valid?
  74. How can I restrict php mail() to only send me one email after a db error
  75. pull data from a remote wordpress database
  76. How to delete post comments from the database via SQL statement?
  77. Users table missing from Database [closed]
  78. Why does changing Database Table Prefixes result in loss of content?
  79. How to connect and insert data in database of wordpress?
  80. WordPress as a frontend website for iOS app [closed]
  81. wp_option table error while importing
  82. wp_insert_user not creating account correctly when ID is manually set
  83. What is wrong here? Issue with post_id and meta_value
  84. WP 5.5, child themes, customizer and a weird cache issue
  85. New Page/Post Screen Opens an Existing Post
  86. How do I change several broken URLs in a several wordpress databases in the fastest way?
  87. Best way to store 1 billion+ posts?
  88. Character encoding issue – black diamond question marks on imported post excerpts
  89. Reinstall wordpress/mySQL caused database problem
  90. How To connect to the same WordPress database with different database user
  91. I have include wp-config, should I add global $wpdb also?
  92. How to have WP Search widget index dynamically generated content?
  93. Preventing concurrent update of data
  94. Where should I put this custom data?
  95. Changing starting number of User ID
  96. Category not displaying in add post, edit post, and categories page.
  97. $wpdb->prepare returns empty array
  98. Prevent creation of unused database tables?
  99. How to store a plain password in WordPress database in another field
  100. Query a meta key using an array of values where the database value is a string

Leave a Comment