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
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
Uma Bhat wrote:
Hey guys!
*MySQL version 5.0*
Hence before doing this, *we want to ensure that
there is ABSOLUTE *no* difference in schema between each of them. (all
datatypes, and other such database objects, engines, MUST be IDENTICAL).*
*QUESTION* - what's the *EASIET way to compare* the
In order to make your workaround less tedious you can write a shell script
that dumps the structures of all 50 databases
basically:
for db in $(mysql [opts] -e 'show databases'); do
mysqldump [opts] $db
Done
Olaf
On 10/5/08 10:15 PM, Uma Bhat [EMAIL PROTECTED] wrote:
Hey guys!
We
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
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
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
Hey guys!
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.
*MySQL version 5.0*
*SCENARIO* - There are 50 mysql databases (which we have been informed that
is of