On 06/12/06, Elazar Leibovich <[EMAIL PROTECTED]> wrote:
I'm having one mysql database FOO, whose schema needs to be changed from time to time. I'm having another database BAR with different data in it but with the same schema. I want to copy schema changes from FOO to BAR. ie, when I add column height to table 'users' and column 'ruby' to table languages in FOO I want to be able to add the same columns to BAR, without changing BAR's actual data. Is there any automatic way to do that? mysqldump doesn't seem to offer such an option.
Searching for "mysql schema sync" in sourceforge.net comes up with numerous projects with descriptions of doing just this. Googl'ing for "mysql schema sync" comes up with many commercial solutions. In general, it doesn't sound like a very hard problem to solve. HTH, --Amos
