WordPress.org

Ready to get started?Download WordPress

Forums

"Merging" Authors (8 posts)

  1. gths23
    Member
    Posted 10 years ago #

    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?

  2. Matt Mullenweg
    Troublemaker
    Posted 10 years ago #

    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

  3. gths23
    Member
    Posted 10 years ago #

    Yep, this worked. Ta!

  4. mboszko
    Member
    Posted 10 years ago #

    Thanks-- this worked for me as well!

  5. Kyramas
    Member
    Posted 10 years ago #

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

  6. Iki
    Member
    Posted 10 years ago #

    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!

  7. OperaManiac
    Member
    Posted 10 years ago #

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

  8. cherrypj
    Member
    Posted 10 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.