I have been working on an updated design of a drupal site. I created a second space and database for the new design. Now I am ready to go live. I have no problem migrating the design over, I am running into a problem with moving new data over that was entered after I started designing.
I need to get new data from the forums, resources, Organic Groups, and calendar events. The forums are the easiest to show what I need.
New design: http://www.uvm.edu/~vtedtek2/forum
Old design: http://www.vtcite.org/forum
I need to get all the data from the old design into the new. I have been using mysql administrator and query browser, along with a demo of navicat to merge the data from one db into the second. I just cannot seem to get the right combination of synchronized tables to do the job.
Is there a better approach? and/or what tables should I concentrate on merging?
-bj
Comments
I would check out the Backup
I would check out the Backup and Migrate module and its documentation.
Backup and Migrate module is
Backup and Migrate module is great if you are moving from one db to another but doesn't help with merging 2 together. What I need is a module or program that compares 2 databases and copies only the new entries. The trick is to only import the tables containing node data and associated information and not any that pertain to design.
another way to look at is the ability to take just the forum posts (or other data type) from site A and add them (not replace them) to the forum on site B.
-bj