Delvering a modified database from the local env to the production one

Question

I'm working with MySQL databases. To simplify the problem, let's say I have two environments : the local one (development) and the remote one (production mode).

In the database, I have some tables that contain configuration data.

How can I automate cleanly the delivery from the development mode to the production mode when I modify the database schema and the configuration tables content ?

For instance, I dot it manually by doing a diff between the local and remote databases. But, I find that method not so clean and I believe there is good practice allowing that.

Answer 1

This might be helpful in cases where you have multiple environments and multiple developers making schema changes very often and using php.. https://github.com/davejkiger/mysql-php-migrations