Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Duzenbury, Rich (rduzenburyBILtd.com)
Date: Tue Oct 07 2008 - 09:07:41 CDT
I just used mysqldiff for a project, and was successful.
From: Uma Bhat [mailto:bhat.umagmail.com]
Sent: Monday, October 06, 2008 7:51 PM
To: Andy Shellam; mysqllists.mysql.com
Subject: Re: Any easier way to compare mysql schema of 50 databases?!
Thank you all, guys!!
i shall try these and respond on which worked best for me.
On 10/6/08, Andy Shellam <andy-listsnetworkmail.eu> wrote:
> I was also going to go down this route some time back, but then when I
> looked at it, it's pretty simple how it works and you can do the same thing
> yourself for free.
> Take a dump of both servers (mysqldump or via MySQL Administrator) of the
> databases in question, then use WinMerge (for free) to compare the dump
> files and (optionally) create a 3rd file which is a result of merging the 2
> by choosing the changes you want to keep.
> I've used this method plenty of times to synchronise changes between
> servers, some that concern 000s of rows of data.
> Granted you cannot do this with PostgreSQL as those dumps tend to be in
> binary format, but it works well for MySQL backups.
> WinMerge: http://www.winmerge.org/
> D. Dante Lorenso wrote:
>> Uma Bhat wrote:
>>> We are in progress of *optimizing* and designing the existing mysql
>>> enviromnent on *linux*. And need help in comaparing schema of 50
>>> databases from the same mysql instance.
>> If you can afford to spend a few dollars to get the right tool, you want
>> to get DB Comparer for MySQL from the folks at EMS:
>> This tool will compare the schemas of 2 MySQL Databases and allow you to
>> selectively choose which changes to make in order to synch to the master or
>> the target DB.
>> I've been using the PostgreSQL version of this tool for many years and
>> just recently started using their MySQL one.
>> -- Dante
>> D. Dante Lorenso
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=bhat.umagmail.com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql