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 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!!! It is not ... a simple shell script will do it for you and can even mail you the results about mismatch. Btw Why don't you consider having a single database replicated across 50 diff machines/servers ? Or is it sharding/partitioning of data across different instances ? Regards, Ranjeet Walunj *Are there any tools available* to accomplish this task? Many Thanks! Uma
