Merge Users

  • johnf

    21 years, 4 months 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

    21 years, 4 months ago

    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

    icebreakerx

    (@icebreakerx)

    21 years, 2 months ago

    Can someone please clarify the way to merge users?

    iddapidda

    (@iddapidda)

    21 years, 2 months ago

    Help would be greatly appreciated 🙂

    marzar00

    (@marzar00)

    21 years, 2 months ago

    I thik we are missing a bit of the thread!

    iddapidda

    (@iddapidda)

    21 years, 2 months ago

    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.

    🙂

    willfulexpose

    (@willfulexpose)

    21 years, 1 month ago

    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.

    georgianlady

    (@georgianlady)

    21 years, 1 month ago

    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.