tongpo - 6:47 pm on Dec 15, 2012 (gmt 0)
Ok I have two databases. They hold similar data. So I have database one and database two.
They both have the same table strucutre with identical tablenames but contain similar but not identical data.
I have added a fseveral fields to database1.tablename and these are now filled with relevant data.
Is there a way I can copy the new structure of database1.tablename(s) to database2.tablename(s) without altering, addding or in any other way shape or form modifying any data the tables contain. Without doing it manually of course.
I simply want to copy the new structure of database1.tablename(s) to database2.tablename(s) - no data. There are several tables this needs to be done for so doing it manually is going to be very tedious.
ANy suggestions? Is this possible?
They are MYSql databases btw