Kobus, it should be possible to write a little MySQL dump script to dump the appropriate tables.
The trick is to note the relationships between nodes and comments and keep these intact.
There's been a number of similar questions lately. Sounds like it's time to address import and export again.
Djun
On 15-Dec-2005, at 5:23 AM, Kobus Myburgh wrote:
Hi!
I will soon upgrade one of my most popular sites to Drupal 4.7. Many things have happened with Drupal since 4.2, so I can improve the site a lot (e.g. inline images, better menu structure, and so on) so I want to transfer each node and its comments together to the new site, and in that way rebuild the site from scratch, posting over node for node (including its comments) one at a time. Recreating each comment one by one seems a bit tedious, as I already have 900 or so nodes to transfer, and keeping track of which comment belongs to which node will be a nightmare... :-(
Anyone with a suitable solution for this? I don't want to loose any comments, as these make up for the character of the site.
If there is no such utility, then I'd have to use PHPMyAdmin and do each and every one manually as an export file, but that seems a bit over the edge.
Regards and thanks in advance,
Kobus
-- [ Drupal support list | http://lists.drupal.org/ ]