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 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 databases ? *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? Many Thanks! Uma
