How to migrate database structure?

Question

MySQL

There are 2 MySQL databases.
Tables have an innodb engine.
How to automatically or quickly migrate the structure of one database to the structure of another database?
If you don't know what has been changed.

Answer 1

There is already a lot of software out there.
The simplest option is to dump the structure from both bases and compare at least with a diff.
Here are different options, from a simple hundred-line script to more serious solutions.
Some tools can generate migrations right away. In my opinion, DbVisualizer can.