One of the ways is to keep db scema under revision control system. And update it every N minutes.
% crontab -l 0 * * * * mysqldump testdb --no-data > testdb_schema.sql && svn ci -m "db schema: `date`" > /dev/null > 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org