Brock Angelo
If you uploaded all of your Media using the Media Library, doing the bulk import will take more work than mine did above. That’s because WP-DownloadManager references files by their full file name (like “brockangelo.jpg”) but WordPress references them by title and mime type (like “brock_angelo” for the title and “image/jpeg” for the mime type). So for this to work, MySQL would have to conditionally concatenate file names to file types. Not pretty.
On the other hand, if you need to make this happen, you can perform the following query to output the results to the screen, then paste them into excel to do the cleanup. From there, you can pull the information back in through MySQL. This query shows you all of the media that is in your library, with all necessary info you would need to put into excel for a MySQL import back into the WP-DownloadManager database:
SELECT post_title, post_date_gmt, guid, post_mime_type FROM wp_posts WHERE post_type = 'attachment' ORDER BY ID
Leave a comment if you would need instructions on how to finish this up.
If you enjoyed this article, please consider sharing it!
Thank for Information
Hi, cool post. I have been wondering about this topic,so thanks for writing.
Thanks for your valuable information. I will try it……
Thank you for this post. This is what I’m looking for.