When I need to do so, I use mysqldump -d to dump the schemas to files, then use "diff" on
the files. It's pretty good at highlighting the differences.
From: Steve Buehler [mailto:steve@stripped]
Sent: Thursday, September 28, 2006 3:06 PM
Subject: comparing two databases
Is there a program out there that I can use to compare two databases? Just the structure,
not the content.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR THE PERSONAL AND
CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE. If you are not an intended
recipient of this message, or an agent responsible for delivering it to an intended
recipient, you are hereby notified that you have received this message in error, and that
any review, dissemination, distribution, or copying of this message is strictly
prohibited. If you received this message in error, please notify the sender immediately,
delete the message, and return any hard copy print-outs.
This message has been scanned for viruses by McAfee's Groupshield.