I have a web application setup where there are separate Apache-Wordpress containers for development and production. Database is hosted externally on a virtual host.
When setting up development environment, I simply take a copy of the Apache container and create a MySQL container where I import dumps from the external database.
Problem arises when I want to update the production environment by replacing the production container with the development container. Updating the development container has made changes to the testing database, for example new tables or schema changes, which are not present in the external database.
How could I update the external database with the changes made to the testing database, without losing data that have come to the production database after I took the dumps?