I have a new install of WP and imported data from the wp -comments, users, posts and the multiple wp_terms... tables in the older install. Everything is OK except that the new db has fewer users. My user id in the new db is 2. In the old db it was 8. So all the posts are shown as being authored by 8 in the wp_post table. Can I just change my user id in the wp_users table from 2 to 8? Or is there a better way to re-associate all the posts to me?
I suppose I could import the old wp_users table from the old db, but there are a bunch of users in there I would then need to delete.