Copy only schema to existing mysql db

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.

开发者_JAVA百科

Is it possible to achieve this?

Please experts help.

---

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.