How can I (semi) automate a database export and import to a different location?

Well, I think you’ve already alluded to the answer. You need to script your database changes. And then run that script on the live database using phpMyAdmin or something like this command if you have terminal access: 

mysql db_name < scripted_changes.sql

If, however, you’ve referring to CONTENT changes then that’s a different thing all together. eg If you edit a post on your dev site and want that post change to be applied to your live site, or if you’ve added and activated a plugin on your devsite. If this is what you want, I am sure there are solutions, but I would recommend you look at your workflow to see if this is necessary.

Related Posts:

  1. Database sync between local and production
  2. Installation with sql server express edition
  3. Trigger Plugin database update after git pull
  4. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  5. Oracle SQL query for Date format
  6. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  7. Can I have multiple primary keys in a single table?
  8. Using wpdb to connect to a separate database
  9. Database connection close
  10. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  11. How to create bulk page and content? [closed]
  12. Importing posts from old website to new conflicting post ID’s?
  13. Exporting revisions
  14. WP_Options ID high
  15. The revisions table in my database is at 70% capacity and growing. What should I do?
  16. WordPress for a very large website
  17. How to use multiple database in wordpress?
  18. WP_list_table bulk_action get edit and delete
  19. How to display data from custom table in wordpress database?
  20. Is removing orphaned wp_postmeta records safe?
  21. stdObject stored in database. How does one convert it to usable format?
  22. What ALL can cause “Another update is currently in progress.”? [closed]
  23. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  24. Set Display Name to first and last name (phpmyadmin SQL Query)
  25. Does WordPress ever need multiple databases?
  26. Why are no posts showing despite my apparently correct DB restoration?
  27. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  28. Cannot update custom database table row
  29. SQL Error wp_commentmeta – incorrect table definition
  30. Change WordPress prefix for only one table?
  31. Two websites one database, administrator not working on second website
  32. Select two sums with single get_var statement
  33. How to get the SQL of the changes made to the database from an update or upgrade?
  34. Merging two wp_posts tables while avoiding duplicates
  35. How to fix the disappearance of the “\” character when updating a post in the database
  36. Data storage for JS app using WP REST API
  37. How to scan barcode and store data into a database [closed]
  38. Fetching values from database for select box
  39. WP CLI Core install – blank database
  40. Update from 4.5 to 4.6 failing
  41. Setup 3 Sites To Connect To 1 Database and Share Data
  42. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  43. fastest replacement DB
  44. Does auto_load to ‘no’ in wp_options improve performance
  45. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  46. Have working sql query… trying to adjust it to use $wpdb
  47. Best host for running large mem and processor intensive WordPress sites?
  48. Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
  49. In which format the data is stored in WordPress Databases?
  50. Strange characters added to the database
  51. Is it possible to rebuild the website while not accesseing the original database?
  52. Error message on blog posts only on my local environment [closed]
  53. how to read database fields
  54. $wpdb->query can’t insert data
  55. Can you refresh ONLY the wordpress adminbar and not the whole page?
  56. After database migration, theme mods don’t show [closed]
  57. Remote database connection and local development
  58. How can I detect right db type?
  59. Add search bar to Custom Database Table in WordPress Dashboard
  60. Design problems when exporting remote database for local development
  61. Website displays old version of page
  62. Image link issues after importing a database backup to my local web server
  63. multiple wordpress installs w/shared user database but separate content databases
  64. A change in URL slug in database returns 404, how can I do auto-redirect?
  65. Updating seperate database when post attachment is changed
  66. add featured image dialog box disappear
  67. Displaying table data on a page
  68. muliple wordpress installs (network) on different databases
  69. White Screen in Home Page
  70. Continuous SQL query errors from outside source
  71. How to get a list of articles related to a particular category from my other WordPress website?
  72. Whats the best practise on how to store json data from a custom settings page?
  73. Recovery – Restore Database after moving folder location locally
  74. Migrate Users From laravel to wordpress
  75. /wp-admin not accessible after migrating to local host (no plugin issue)
  76. Job and Employee Performance Tracking with Product Safety
  77. how add more field to wp user and save it to database
  78. set_transient fails if the value has more than 60.000 characters
  79. How do I cleanup my database with data that is no longer being used?
  80. Malware in old website – how to migrate?
  81. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  82. How to optimize wp_option table?
  83. How can I get $wpdb to show MySQL warnings?
  84. About wp database hooks (error establishing connection)
  85. How to display $wpdb->insert_id; value on redirected page
  86. Database for JQuery Autocomplete field
  87. Create Tables in WordPress
  88. Catchable fatal error in formatting.php
  89. Wrong url for the images while using same database for two WordPress installations
  90. WordPress Failed to Login (DB Error)
  91. Sending WordPress database information to cross domain the safe way?
  92. Database Name Change
  93. Share WordPress Database
  94. Where To Find bb_profile_data(); In bbPress?
  95. ERROR: “Table Prefix” must not be empty
  96. How do you build a database-centric site in WP?
  97. Attach posts based on category and position
  98. SQL query to rewrite all media URLs to end with .webp
  99. Weird WP -Cli Error Connection Refused
  100. Many images in wp-content/uploads folder that are not in Media Library