Solution for database version control and deployment?

Here are two possible solutions, both of these are actually generic MySQL version control tools but can be adapted to your workflow:

dbv.php

This tool creates “migrations”, which are basically SQL scripts, from the changes detected on the database. These scripts are stored in a local directory and thus can be commited to your current VCS (git, for example).

It’s used through a PHP web interface.

DBVC

Fundamentally similar to the previous tool, this is based on a command line interface. It’s configured through a json file. The main difference is that it doesn’t auto-generate the migration files.

There’s a pending issue to integrate this with the previous similar, so that’s something to look for.

WordPress Plugins

Some plugins that could aid in the creation of a repeatable workflow:

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  4. How to migrate a HTTPS WordPress installation to localhost?
  5. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  6. Migrating data between local and development server
  7. Best way to import users, post and categories from an external database
  8. Syncing local content with development / staging sites
  9. Organizing WP Pages based on old website database
  10. Presentation vs Content in WP DB-Tables
  11. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  12. Migrate a Non WordPress database to wordpress [closed]
  13. storing database in version control
  14. Weird issue with database migration and SSL links
  15. How to fix unchanged URLs in Database after running serialized search and replace script?
  16. Migrating database / content of non-CMS site to WordPress
  17. How do I reset a self-hosted WordPress URL?
  18. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  19. Export all content from wordpress
  20. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  21. Moving minor updates between local and live sites – just database?
  22. How to move the WordPress site Layout from test site to Production site?
  23. Merging two databases without borking it
  24. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  25. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  26. Trouble Migrating all data blog from WordPress.com to WordPress.org
  27. Copying database tables to new database
  28. Migrating from PDO using SQLite to clean new install using MySQL
  29. Migration: Copying database content to a different server
  30. Change WordPress URL in sql file via Terminal
  31. Strange characters added to the database
  32. After database migration, theme mods don’t show [closed]
  33. Problem migrating to localhost
  34. WordPress url transformation script
  35. How to transfer from localHost to live but use the already existing database on the server?
  36. Image link issues after importing a database backup to my local web server
  37. Database migration issues – Error #1046 No database selected
  38. echo site_url() returns a different value than what is in the database siteurl field
  39. Migrate Users From laravel to wordpress
  40. /wp-admin not accessible after migrating to local host (no plugin issue)
  41. How to fix Uploaded to this post option to see group of images uploaded to a post?
  42. How do you enable scripts on a WordPress installation in Softaculous?
  43. WordPress site migration – locked out of admin area
  44. Malware in old website – how to migrate?
  45. WP website showing blank page after moving from subdomain to main domain
  46. WordPress Migration – Issue with admin panel changes
  47. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  48. How to edit posts/pages without making the change live?
  49. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  50. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  51. I cannot change anything in my wordpress database from within wordpress?
  52. Media library images “missing” after migrating them using SQL
  53. version control for wordpress? (wordpress folder and database at same time)
  54. Restoring .sql backup results in “Error establishing a database connection”
  55. import (migration) user database to wp-users
  56. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  57. Moving database from WP 2.6 to 3.5 problem
  58. Importing Concrete5 content to WordPress
  59. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  60. get_results using wpdb
  61. WP Multisite: load content from site X on site Y
  62. How to execute mulitple statement SQL queries using $wpdb->query?
  63. Store and Encrypt Contact Form 7 Submissions in Database? [closed]
  64. Database with mixed collation (utf8mb4 & utf8_general_ci)
  65. WordPress database growing dramatically in size despite adding no new content
  66. Clean database from unused tables
  67. How wordpress accesses its own database
  68. Delete all post meta except featured image Using SQL
  69. How to scan barcode and store data into a database [closed]
  70. Fetching values from database for select box
  71. Connection refused on locahost after importing database?
  72. When to use custom DB tables or add_option?
  73. creating new field on mysql
  74. Does WordPress store the username as a primary key in the database?
  75. Database Update Required – Update from command-line
  76. SQL query to set posts in bulk based on the post content
  77. Automate WordPress website setup with prefilled data
  78. Custom search query by category id
  79. multiple wordpress installs w/shared user database but separate content databases
  80. Fetch a single row from a custom table for to a given ID
  81. Database create or redirect
  82. Updating seperate database when post attachment is changed
  83. Database structure cheatsheet
  84. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  85. How to get a list of articles related to a particular category from my other WordPress website?
  86. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  87. error establishing database connection (WAMP + filezilla)
  88. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  89. How do I update a WordPress wp_postmeta meta_value that contains many options
  90. How can I get $wpdb to show MySQL warnings?
  91. Auto populate form fields based on serial input or pull listings from other websites?
  92. How to extract some part of WordPress full source code
  93. Error establishing a database connection for some files
  94. Hash user emails in database?
  95. DB access blocked when initializing WP externally
  96. Saving data to database and exporting to excel
  97. Site does not work right, pages not showing up, even for root admin
  98. One information repeated on multiple locations on one site [closed]
  99. WordPress: Interact with Database Query Data and Login
  100. Showing Error(TAble already exist)

Leave a Comment

techhipbettruvabetnorabahisbahis forumueduseduedusedueduedusedueduseduedu