From: Duzenbury, Rich (rduzenburyBILtd.com)
Date: Tue Oct 07 2008 - 09:07:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I just used mysqldiff for a project, and was successful.

-----Original Message-----
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.

Regards,
Uma

On 10/6/08, Andy Shellam <andy-listsnetworkmail.eu> wrote:
>
> Hi,
>
> 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/
>
> Andy
>
> D. Dante Lorenso wrote:
>
>> Uma Bhat wrote:
>>
>>> We are in progress of *optimizing* and designing the existing mysql
>>> database
>>> 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:
>>
>> http://www.sqlmanager.net/en/products/mysql/dbcomparer
>>
>> 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
>> dantelarkspark.com
>>
>>
>>
> --
> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]