Re: How to synchronize two database tables in MySQL?

[bsb]

Alzabo has schema diffing and altering capabilities. You may be able to automatically import you schemas and then generate the ALTERs required.

It's been a long time since I used Alzabo, so I'm not sure of the current status or whether this plan is feasible. Perhaps someone else can provide more up to date information.

Usually I just diff the schema dumps and migrate by hand. But as I have only one deployment it's easy.

mysqldump dev  -d --add-drop-table=false > dev.sql
mysqldump live -d --add-drop-table=false > live.sql

perl -pi -e 's/^--.*\n//;s{/\*.*\*/;\n?}{}' dev.sql live.sql 

diff -B -U 5 dev.sql live.sql > schema.diff

Brad