Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Alexander Kolesen (kolesen.agmail.com)
Date: Sat Jan 23 2010 - 09:03:56 CST
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.
> Randall Price
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql