I just used mysqldiff for a project, and was successful. -----Original Message----- From: Uma Bhat [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2008 7:51 PM To: Andy Shellam; mysql@lists.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 <[EMAIL PROTECTED]> 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 >> [EMAIL PROTECTED] >> >> >> > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
