If they are both WordPress, you can export and import them easily using PHPMyAdmin.
If they are different, then you can use one of the many importing scripts that come with WordPress and are also found here:
http://codex.wordpress.org/Importing_Content
There is also the old copy and paste routine, though comments might get tricky. Best go with an import.
Thread Starter
moshu
(@moshu)
Thanks, yes they are both WP. I knew about the possibility to export-import the whole blog through PHPMyAdmin. I’ve done that earlier. I guess I will have to dig deeper into this to figure out how to go when I want to move only certain posts and not the whole db.
(:: sigh:: I hate to mess around with the DB 🙂
moshu, you can export just certain parts of tables. F’rinstance, open your db in phpMyAdmin, then browse the wp-posts table. Check the boxes next to the posts you want to export, scroll to the bottom of the page, and where it says “with selected” click on the “export” icon. Comments have to be done separately, in the same manner. Once you’ve imported them into the db where they need to live, you should be able to “reattach” the comments to their appropriate posts (I think – I should point out I haven’t tried to do this!)
BACKUP DATABASE FIRST!!
Thread Starter
moshu
(@moshu)
Thank you very much! I’ll take a deep breath and jump into it. I’ll report back about the succes (or – God forbid – failure).
Please do – I’m sure those of us with multiple blogs will run into this situation eventually!
BTW, you might need to tweak the wp-comments table in the db after import to assist in “reattaching”….
Thread Starter
moshu
(@moshu)
Follow up.
I succeeded in moving the posts with the method proposed by vkaryl above. I even wrote a tutorial kind of post about how I did it.
Hey, that’s great, moshu! Glad it worked out for you…. heading over to bookmark your tutorial, thanks!
