“Merging” Authors

  • Everything’s going nicely, except I was a little lackadaisical during the import-mt procedure and didn’t set the author to the existing admin account created by the install. So, with my single author blog, I’ve now got the old posts on one user and the new posts as another. I don’t particularly want to keep track of two logins and would like to have all those posts under one name, so is there some way I can change all the posts from one “author” to another, effectively merging authors?

Viewing 7 replies - 1 through 7 (of 7 total)

  • Try this SQL query, where 2 is the author you want to merge into 3.
    UPDATE wp_posts SET post_author = 3 WHERE post_author = 2

    Thread Starter gths23

    (@gths23)

    Yep, this worked. Ta!

    Thanks– this worked for me as well!

    Another happy user here… !
    And I was wondering how can I get my posts back !
    Now I own them all ! hehe !
    Thanks Matt !

    Holy COW… my first attempt at doing anything in phpmyadmin and it worked perfectly!
    I am flat-out unable to articulate how thrilled I am with WP. Whee!

    allusion why cant admin do user profile editing/post ownership changes from the backend ??

    I love Dreamhost. They have phpMyAdmin installed, and from there, I easily merged my MT user into admin.
    Still, it would be nice if WP, in the import-mt procedure, mentioned that setting the author to the existing admin account created by the install is a good thing.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘“Merging” Authors’ is closed to new replies.