in reply to How to synchronize two database tables in MySQL?
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
|
|---|