How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?

Really no easy way to do what you are wanting to do, but what I would do is make a snapshot of your site, implement yoru changes and if anything brakes restore and try again. It might be down for an hour, but I just recently did this when I somehow bricked a site I was working on. This might not be the “right” way to solve the problem however for me it works. Good luck.

Related Posts:

  1. How to fix unchanged URLs in Database after running serialized search and replace script?
  2. Merging development site with live site
  3. MySQL Database User: Which Privileges are needed?
  4. Database synchronization between dev/staging and production
  5. Multiple developers / editors working on a site in progress
  6. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  7. Safest way to bulk delete post revisions
  8. Solution for database version control and deployment?
  9. How can I make a WordPress database portable and url independent?
  10. How to migrate a HTTPS WordPress installation to localhost?
  11. Why does $wpdb return strings for mysql integer values?
  12. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  13. Dealing with Many Meta Values, 30+
  14. When is it appropriate to create a new table in the WordPress database?
  15. Migrating data between local and development server
  16. Is it possible to switch the data layer within WordPress?
  17. Best way to import users, post and categories from an external database
  18. Syncing local content with development / staging sites
  19. Organizing WP Pages based on old website database
  20. store simple data in get_option()
  21. Presentation vs Content in WP DB-Tables
  22. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  23. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  24. Have multiple local wordpress installs share a wp-content folder and database
  25. Migrate a Non WordPress database to wordpress [closed]
  26. How to implement content from external database into WordPress text page? [closed]
  27. Cloning and syncing a WordPress website
  28. Suggestions for WPMU Migration (advanced)
  29. What actions affect files, DB, or both?
  30. Add search Value to wp_list_table pagination
  31. Weird issue with database migration and SSL links
  32. Merging WordPress posts from different databases
  33. Migrating database / content of non-CMS site to WordPress
  34. How do I reset a self-hosted WordPress URL?
  35. Should non-WordPress data get its own DB?
  36. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  37. Who is responsible for data sanitization in WordPress development?
  38. Search and replace special characters (å,ä,ö) for image attachments only in database
  39. Export all content from wordpress
  40. Merge two WordPress installations into one, and keep posts separated?
  41. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  42. Moving minor updates between local and live sites – just database?
  43. How to move the WordPress site Layout from test site to Production site?
  44. Merging two databases without borking it
  45. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  46. How to merge two WordPress databases with the same structure?
  47. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  48. Localhost to Staging to Development Dynamic WP-CONFIG
  49. Setup 3 Sites To Connect To 1 Database and Share Data
  50. Trouble Migrating all data blog from WordPress.com to WordPress.org
  51. Copying database tables to new database
  52. Migrating from PDO using SQLite to clean new install using MySQL
  53. Migration: Copying database content to a different server
  54. Uknown meta entries in wp_postmeta
  55. Change WordPress URL in sql file via Terminal
  56. creating new field on mysql
  57. Strange characters added to the database
  58. How to transfer one domain to another domain without losing theme options (customizer)?
  59. Why user_pass column in wp_users table is varchar(64)
  60. After database migration, theme mods don’t show [closed]
  61. Problem migrating to localhost
  62. Can local WordPress installs share /wp-content/ folder and database?
  63. WordPress url transformation script
  64. How to transfer from localHost to live but use the already existing database on the server?
  65. Image link issues after importing a database backup to my local web server
  66. SymmetricDS in dev + prod workflow?
  67. Database migration issues – Error #1046 No database selected
  68. echo site_url() returns a different value than what is in the database siteurl field
  69. Migrate Users From laravel to wordpress
  70. /wp-admin not accessible after migrating to local host (no plugin issue)
  71. How to fix Uploaded to this post option to see group of images uploaded to a post?
  72. Migrating my site to a new domain does not keep any changes made in customizer
  73. How do you enable scripts on a WordPress installation in Softaculous?
  74. WordPress site migration – locked out of admin area
  75. Malware in old website – how to migrate?
  76. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  77. WP website showing blank page after moving from subdomain to main domain
  78. WordPress Migration – Issue with admin panel changes
  79. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  80. WPCLI search and replace in a particlar site dir effect another site-dir
  81. How to edit posts/pages without making the change live?
  82. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  83. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  84. I cannot change anything in my wordpress database from within wordpress?
  85. One WP Database outside localhost and two connections
  86. Media library images “missing” after migrating them using SQL
  87. Get id from database
  88. Restoring .sql backup results in “Error establishing a database connection”
  89. import (migration) user database to wp-users
  90. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  91. Share WordPress Database
  92. MySQL Database User: Which Privileges are needed?
  93. Moving database from WP 2.6 to 3.5 problem
  94. Importing Concrete5 content to WordPress
  95. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  96. Most Flawless Way To Transfer from Dev to Prod [duplicate]
  97. Corrupt WordPress Database
  98. Building a Scalable Resiliant WP Setup
  99. Single database for multiple instances
  100. Have WordPress Use a Different Database for users

Leave a Comment