Re: MySQL WB Utilities: Diff / Alter generation by dump

[Charles Bell]

Hello,

My suggestion is to use mysqldiff. But first, you will need to take the script you generated and load it onto the development server as a different database name. For example, if the db in question is caravan, create it as caravan_old (or some such). Then, use mysqldiff to connect to the development server comparing caravan_old to the actual, production database server.

For example, if my development server was localhost and my production server is 10.0.1.1, I would use a command like the following (substituting password and supplying the port if needed).

mysqldiff --server1=root:password@localhost --server2=root:password@10.0.1.1 caravan_old:caravan -d SQL

Your options may vary.

The result will be a comparison of the structures in caravan_old to those in caravan thereby documenting what is different or changed.