Merging two databases?

Question

MySQL

There is a site in php using Yii, prod and dev environments are made for it. New functionality is tested on a dev before being rolled out to production, and content is added to the database during this testing. Prod at this time is functioning normally, processing user requests.
How can I also synchronize the database when deploying changes on the site from dev to prod?

Answer 1

migrations to change the structure.
seeds for data.

Answer 2

No need to transfer data from dev to prod. Don't make the basic mistake