Merge Users

  • johnf

    20 years ago

    Hello,
    I have imported my posts from Blogger and have my username (with Blogger) and the site admin (with WP). I have used both usernames to post items. If I delete the Blogger user will the posts be deleted?
    And, how can I make a user a site admin?
    Thanks!!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter Anonymous

    Thanks so much for your help. It works perfectly.
    For anyone that needs it use this:
    UPDATE wp_posts SET post_author = ‘1’ WHERE post_author = ‘2’;
    1 is the new user
    2 is the old user

    Can someone please clarify the way to merge users?

    Help would be greatly appreciated ??

    I thik we are missing a bit of the thread!

    Bleagh.. I should have read this a bit better.
    This line
    UPDATE wp_posts SET post_author = ‘1’ WHERE post_author = ‘2’
    is what needs to be put in phpmyadmin on your site. Worked perfectly for me.

    ??

    Worked great for me as well. Please note that if you’ve changed the name of your WP databases, you may need to change the “wp_posts” part of the line.

    Thanks for this! I used it on two of my blogs where I had imported my old weblogs to wp a long time ago and messed up choosing the right author –so now all my posts are my own again and I can get rid of my second self on each ??

    It worked flawlessly and fast!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Merge Users’ is closed to new replies.