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. Updates applied to staging WordPress site affecting production even with different databases
  66. Store a default value for a transient on plugin activation
  67. Long running queries
  68. How WordPress reacts to a lack of memory of the server [closed]
  69. Split reads to a different connection string
  70. custom user role wordpress – grant guest access to edit.php without insert/update/delete
  71. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  72. Execute long and heavy processes
  73. Hacked WordPress website /Homepage redirect [closed]
  74. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  75. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  76. Dynamic content in template
  77. Weird 404 URL Problem – domain name being placed at end of urls
  78. wp query foreach deleting record returning only first or last item
  79. Refresh table data with Ajax
  80. How to import a custom MySQL DB table into a WordPress custom post type
  81. Database query works fine outside WordPress
  82. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  83. $wpdb->wp_users returning empty value for
  84. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  85. $wpdb->insert() does not Insert record in a table
  86. Databases – Submitting data from inputs to database [closed]
  87. Help with a $wpdb MySQL Query
  88. db converts decimal number wrong
  89. WordPress SQL injection
  90. Way to bulk make all my tags lowercase?
  91. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  92. How i can obtain all the post meta for a specific post as an array?
  93. multiple where condition in result query
  94. Grouping posts by a custom meta value
  95. Filtering a Database Query
  96. Multiple meta_key in one global $wpdb;
  97. Custom array from a query only write the last row of the query
  98. Display Data in Table from External Database in WP using Shortcodes
  99. WordPress member notification
  100. Is it best to avoid using $wpdb for security issues?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)