Best way to synchronize two database schemas

[Randall Price]

I have a two databases, one in a production environment (let's call it db_prod) and the
other in a testing environments (Let's call it db_test).

What is the best way to synchronize the database schemas?  db_test has had a few indexes
and constraints added to several tables and I need to generate a MySQL script to apply
these changes to db_prod.  So basically I want to dump the schemas of the two database,
compare, and generate the necessary script to apply to db_prod.

Thanks,
Randall Price