Hello. I'm re-organizing my blog. I currently have a main blog with three sub-blogs, in three subfolders of the main folder. Back in 2005 it had sense to make it that way... but now I wish to merge all the sub-blogs with the main blog. I know I can manually copy all posts in the sub-blogs as posts in the main blog, one by one... but that would take a lot of time.
I suspect that all the posts in the DB have a unique ID regardless of the blog they belong to, and also that posts are retrieved for each blog using a 'Blog ID' field. Am I right? Then, there should be easy to move all the posts at once to the main blog just by accesing the database table and changing the 'Blog ID' to the one that identifies the main blog, right?
If so, the question is: which tool (or tools) can I use to access the Blog database directly?
Thanks in advance and best regards,
PS. As always, Blog (with initial uppercase) = the program / blog (all lowercase) = the web log.