Well I have recently moved my forums from my own server to a payed server, and since my old forums where bogged down with many unfinished/junk codes I decided to create a new installation. Problem is, that many of the mods on the odl forum, are not on the new one, and there are enw mods on the new forums that were not on the old ones. The problem is that the databases have different fields in them now, almost the same, but just a few differences.
I tried many things, but I do not see a feature in mysql where is will take the data from one table, move it to another, and just use the rows that are there now, and delete the ones I don't need.
So what I am trying to do, is use the old tables that have fields
ex: Announcement_global, id, Anouncment_duration
and place that data into a table that has fields
ex: id, Announcment_duration, gl0bal_announce
So what I want to know is how do I go about preserving the users, posts, etc by transfering them into the database without having to do much editing.
Thanks for the help in advance.