Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Uma Bhat (bhat.umagmail.com)
Date: Sun Oct 05 2008 - 21:15:03 CDT
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 same schema - we are not sure)
We are planning to consolidate the data spread across these 50 databases
into a SINGLE database . 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 schema's of ALL these 50
*WORKAROUND* i could think of - taking *mysqldump* of database (with *
--no-data* option) and compare with *'diff'* UNIX command.
BUT, this is a VERY TEDIOUS to carry out this process for 50 databases!!!
*Are there any tools available* to accomplish this task?