I just installed drupal as blog software and converted the old blog entries to the new table format.

This is (a part of) the SQL code:

INSERT INTO node_revisions SELECT a.id, a.id, 1, c.value, b.value, SUBSTRING_INDEX(b.value, '.', 6), null, changed, 4 FROM public_websites.ndev_liveContent a JOIN public_websites.ndev_liveContentData b ON a.id = b.content_id JOIN public_websites.ndev_liveContentData c ON a.id = c.content_id WHERE b.name = 'body' AND b.language_id = 1 AND c.name = 'title' AND c.language_id = 1 AND a.parent_id = 1 AND a.type_id = 9;