Hi. I've looked through the manual for this but still need info. Sorry if I overlooked something. We have over 200 blogs sites on our 3.2 platform. We moved to a new server with an upgrade to 4.1. We want to update the templates (global and otherwise) and change a few more settings which takes time. Then I was hoping to import the entries (content and comments) into the new platform and preserve the templates/ setting for all the blogs on the new platform.
What tables/data needs to be exported out of the old platform? What about the photos or other assets that might accompany the new content. The new content would be what has been added between the first migration and upgrade to the date at which all the blog templates have been upgraded to our new design – a few weeks at most.

Thanks in advance,
Tony

dbl-post

It looks like it might be as easy as going into mySQL and pulling a csv file from this query:
SELECT * FROM `movabletype`.`mt_entry`; where the entry_created_on is greater than some date.
And then importing that into the new platform's mySQL db.


I also noticed that there is a differnce between the two versions of the same table. These fields do not exist in the 3.2 version:
entry_meta (all null in my instance)
entry-authored_on (same as value in entry_created_on)
entry_template_id (all null)
entry_class (all 'entry' in my case)
Anyone been down this road before?

Update 11/17:
I was able to import the data from both the mt_entries table and the mt_comments table. The mt_comments table in the new version as one more column than the earlier version (comment_parent_id) which is null.
Weird result is that the comments are visible in the MT admin panel but not the entries.

Has anyone attempted this successfully?

Thanks in advance,
Tony