Easy way to bulk edit media author?

  • Resolved colkav2015

    (@colkav2015)


    7 years, 11 months ago

    Hi,

    I’ve uploaded about 70 images whilst logged in as ‘user a’, and now the images Author show up as ‘user a’. What I need to do is change the author for all images to ‘user b’:

    Is there any quick and easy way to do this?

    It’s not like bulk editing Posts / Pages: there’s no bulk edit option for Media.

    Many thanks in advance,

    colkav2015

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    You can use phpMyAdmin, usually accessed through your hosting account. The first thing to do is make a backup of your DB because you can really scramble your DB with a bad query in phpMyAdmin.

    Your goal is to build an SQL update query that sets the post_author field to a particular user ID where the current post_author is the ID of user a and the post_type is attachment. Add a LIMIT clause to test your query on only one or two attachments. Once you’re 110% satisfied all is well, you can remove the LIMIT to update all remaining records. You must be sure, there is no undo except for restoring from backup.

    Thread Starter colkav2015

    (@colkav2015)

    Many thanks @bcworkz for your clear explanation. I was hoping a plugin could do it because I don’t ‘speak’ SQL. I’ll certainly look into it!

    All the best!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Easy way to bulk edit media author?’ is closed to new replies.