Copy only schema to existing mysql db

Question

Hi,

I have 2 db mysql at two locations, i need to copy the schema from first to the second one without hurting the data that is already existing in the II location.

Is it possible to achieve this?

Please experts help.

Answer 1

Databases are usually too complex to allow a simple "copy".

Use Toad's database comparison/scripting tools (or something like this: http://adamspiers.org/computing/mysqldiff/) to find the differences, check and run them manually.