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.
精彩评论