I would like to know if there is an easy way to download or export blogs and forum posts by username/uid. By easy, I mean less time consuming than having to copy/paste the information manually.
We have been running a blogging site for 7 years, with thousands of users and thousands of blog and forum posts. We are getting rid of our dedicated server and would like to retain blogs from a certain amount of users who have contributed throughout the years. We are currently on drupal 6.28.

From phpmyadmin:
I have exported the node revisions table (because it seems that is where the content from the blogs are, but if there is another place please let me know), but it is huge.
I have tried:
CSV - page error
CSV to MS Excel - received info but it is hard to read
XML- page error
Word Doc- file too big to open

Also, I would like to be able to download by each user so that I can have the files separate to send to each of them, rather than one huge file with all of our blogs in it. I don't know how to narrow the information down to get it by user. I have done a search to narrow it down, but when I export it takes all of the nodes.

From inside Drupal: I have also downloaded the backup/migrate module, but I'm not sure that is for what I am trying to do. Is there even a way to get that information from ftp'ing into the site, or is it all on the database?

Thank you for any help you can give.