I'm adding a log to my site under a different domain that will hold most of my personal entries while leaving my current log to host my more weblogish things.

Right now I have then categorized perfectly so I can tell which entries are which really easily.  I've even found the parts of the MySQL database that notate which entries go into which sites and categories.  My problem is that I have over two hundred entries to move and the data I need to determine which is to be moved is in a table other than the one I need to change to move them.

Is there an easier way of moving entries between logs based on the category or am I just going to have to play the SQL game for a day?  I really, really want to keep the same ID numbers for other reasons.

The only other way to move the entries would be to export the category from one blog and import into the other - but then you will lose the entry IDs - new ones will be assigned on import, as each entry ID is used only once.

never mind, this solution was something in your original post.  LOL, I need to learn to read!