That's probably the simplest way. mysqldump --no-data -u someuser -p mydatabase > current.sql and then diff it to howitshouldbe.sql created in the same manner.
holli
You can lead your users to water, but alas, you cannot drown them.
Comment on Re^2: Tracking and deploying changes in (MySql/Maria) DB schema ...
Maybe I should have been more explicit about needing the incremental steps (i.e. ALTER TABLEs)
So you need auditing. The audit plugin [1] seems to be made for this. As expected it has a QUERY_DDL setting which is pretty much what you seem to need.