How to merge local and live databases?

If you just merge the local DB into the production DB it actually means that your local install is a production as well. The problem is not with the ability to perform merge, the problem is that you don’t have a separation between production staging and dev servers.

DB on dev installs are likely to contain garbage values of some sort and you might get unexpected results if you just “merge”.

Your software design should avoid DB settings unless they actually should be used by a user. Avoid “development by DB values” tools like ACF, override and hardcode the values stored in options that the user will not change but you need to set for the configuration if it is a bought theme.

Once there is no setting in the DB which you use to control the behavior of the site the whole merge problem disappears.

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Check if post of title already exists
  3. $wpdb->delete column values IN ARRAY()?
  4. How To Make Connection To WordPress Data Base In A Plugin?
  5. Changing user_nicename
  6. Does WordPress cache get_user_meta() results?
  7. WordPress will not operate correctly
  8. How to Join two tables from separate databases within WordPress
  9. error importing localhost export file to server
  10. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  11. How to sort results from a custom database table
  12. How can I call a row of user specific data from a custom table added to the WP Database
  13. How to track a users progress through pages by inserting data into WordPress Database?
  14. Import 10,000 Users into WordPress WITH a specific ID for each user
  15. WP database error for comments_popup_link()
  16. if statement on database query
  17. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  18. No wp-config.php file on local install of wordpress – site still displays
  19. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  20. Different database query in function.php using mysqli
  21. How to create and work with custom data / tables (i.e., for arbitrary data)?
  22. Create WP_Query to search for posts by their categories or their parent/child categories
  23. WordPress not reflecting changed of the database
  24. How can I save unique user data on my site? [closed]
  25. Update results, Before deleting the related category [closed]
  26. database sent to a JSON file
  27. inserting a post from an extern php file but post content doesn’t show on wp site
  28. Using custom tables for old posts
  29. Not connecting to database in file with multiple MySQL connections
  30. WordPress Block developer from exporting Database via PHP
  31. wpdb prepare insert table doesn’t work
  32. Should I use WordPress to skin a database website?
  33. How do I display offsite database info on my wordpress site?
  34. Creating Database Table vs. Adding MetaData to Post & User
  35. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  36. Most commented posts by time period (last 12h, last 24h and etc)
  37. I can’t update my data through $wpdb
  38. Why when I create a new post I found 2 record related to this post into the posts database table?
  39. Adding data to custom wordpress database table
  40. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  41. Add row to custom database Table and delete all rows older than 1 day
  42. select a single val though a table in wordpress
  43. SQL error with custom query
  44. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  45. Please help! I have a problem with getting wordpress databas
  46. Error establishing a database connection (Set-up locally)
  47. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  48. Using wpdb to connect to a different database is not working
  49. Insert data from form to database
  50. can’t delete a row from post_meta table
  51. How to set max users to 17.000
  52. two wordpress sites, two themes, one database, same content
  53. Insert double entry in DB
  54. How to connect database table to each registered wordpress user.
  55. Let users register weight each day and save it in DB
  56. MySQL database migration to WordPress
  57. Custom query_posts() parameter
  58. How to pass username into form that sends data to database
  59. How to edit the default database of WordPress [closed]
  60. Display total count of products in orders of a specific order status
  61. Execute multiple PHP Snippets causes error?
  62. Custom form that stores data in mysql database
  63. Putting form result in my database
  64. Can’t insert into a database wordpress
  65. Fatal error: Call to undefined function mysql_connect()
  66. How to add query vars with paginated URLs?
  67. Install will not load: PHP does not have MYSQL installed
  68. Insert post without actions/hooks
  69. Sortable admin column for one meta key with three possible meta values
  70. WordPress Ajax Custom Query – High CPU LOAD
  71. AJAX in WordPress, sending coords data to MySQL and show after into map
  72. Is there a way to get 3+ dimensional array from a single MySql command
  73. Can’t get wp_insert_post to work
  74. Importing Geo data into wordpress database
  75. PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
  76. php include not working in custom page
  77. email alert for product availability
  78. wpdb Cannot Update column in Database
  79. How do I prepare strings for insertions as values into a MySQL table?
  80. add category to posts with tag wordpress
  81. How can I Use 2 databases with one WordPress install
  82. WPDB – Read and write value from / to database
  83. How to Generate a list of Most Commented post?
  84. Why won’t this wpdb get_results query return results?
  85. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  86. Tracking Visitor LatLng with WordPress using JS, PHP. How to put data which was extract using JS into DB
  87. AWS Lightsail WordPress – connect to database on instance using mysqli
  88. call to undefined function mysql_connect
  89. Confuse between forms and tables
  90. code that I can run, or a plug in to show what sql tables something pulls information from
  91. How to edit content in WordPress and the Polylang – plugin? – with demosite
  92. Prepared DB Query from _POST array
  93. I changed the password for the database user of my website, updated wp-config.php and wordpress asks to be reinstalled
  94. I want to use wordpress database in android app using json encode?
  95. WordPress upload images not displaying
  96. how to check for wordpress Query errors
  97. Host does not allow remote connection, so how do I transfer data to my WordPress site?
  98. MySQL Engine vs. Charset
  99. How to check if a value exists in one of two database tables
  100. How to get the last date updated of postmeta?