Take a structure-only (no data) mysqldump on both servers, and then use your choice of diff tools (command-line diff, Eclipse, BeyondCompare, etc.) to compare them. Certainly not a particularly elegant solution, but it's served me well in the past.
cheers, barneyb On Tue, Jul 14, 2009 at 4:24 PM, Marie Taylore<mt4yl...@yahoo.com> wrote: > > What's the easiest & quickest way to compare two MySQL Schemas (databases)? > > I don't need to compare the *data*... just the tables and their field > definitions. > > My production instance is getting an error that my test instance is not. The > code is identical, so I figure I must have left something out of the database > updates, but going through all those tables and fields by hand will take > forever. > > Just thought I'd see if anyone here has any tips. > > Thanks! > > MarieT > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4