How can I UN-orphan media files?

This is random, but a friend of mine got himself into the same situation a two weeks back and found this plugin to be helpful.

https://wordpress.org/plugins/media-sync/

But as Tom mentioned above in his comment, you’ll run into attachment post type issues.

Hope this helps you get half way there!!

Related Posts:

  1. MySQL SELECT increment counter
  2. Exclude Statement in SQL
  3. Custom form that store input in database
  4. Restoring WordPress posts from database only
  5. Can a post ID be 0?
  6. Issue with wp_insert_post and post_content field error Could not update post in the database
  7. wp_posts – guid update
  8. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  9. what is the wp_5_posts table in the database?
  10. Migrating data between local and development server
  11. WordPress Database Charset/Collate
  12. How might I retrieve a featured post image from an external WP site and display it as a link back?
  13. What is the database table for pages?
  14. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  15. WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
  16. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  17. storing database in version control
  18. What’s the most efficient database method to add and query usermeta?
  19. How to solve slow WordPress site caused by attachment_metadata
  20. Is database safe after merging a branch of a more recent version over an older one?
  21. Hook to be used when creating a database table
  22. Delete all post meta except featured image
  23. Where is custom template file chosen for a post stored in the DB?
  24. How do i get user data from a custom table in the wordpress database by user ID?
  25. Large database causes slow load
  26. Safe way to find last inserted id in a table?
  27. WordPress DATABASE Update Manually?
  28. Is it possible to store visitors IPs in wp_postmeta table?
  29. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  30. Multiple postmeta with same name for one post in wp_postmeta table
  31. Which is more efficient? Using usermeta, or creating a new MySQL table?
  32. Export all content from wordpress
  33. Show content from database
  34. Customize JSON output
  35. CRUD operations using WordPress database API
  36. How do I get WordPress login to ignore the password input if a particular username is used?
  37. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  38. “Error establishing a database” connection on some sites
  39. change wp user status from wp_users table
  40. WordPress is not creating table in database after activating plugin,
  41. Is MariaDB’s Aria storage engine suitable for WordPress?
  42. Difficulty importing my live site to local
  43. How do I delete these post types in my WordPress database?
  44. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  45. How do I query wp_options for expired transient pairs with MySQL commands?
  46. WordPress returns to an old version
  47. WordPress running SQL query to update database from form
  48. How to fix database error duplicate entry
  49. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  50. WPDB SQL query with prepare() returning variable, not db value
  51. Get value form wordpress database
  52. Moving to another server database connection error [closed]
  53. Why user_pass column in wp_users table is varchar(64)
  54. Why this query is not showing any result on wordpresss home page?
  55. How to migrate a database from a server to another
  56. How to display content from external db with relevant urls
  57. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  58. Connect to another WP install and grab post based on custom field
  59. Which table (and column) has the content of configured get_post_meta?
  60. Serialize data before inserting into the DB
  61. how to count click tab menu and insert to database
  62. Adding prefix to WordPress database tables breaks admin capabilities?
  63. What is the best way to resurrect and update my old WordPress site?
  64. Using $wpdb | checking entered email against existing emails in db
  65. content disappearing minutes after it’s published
  66. What is the most efficient way to reset a WordPress site?
  67. wp-cli: Error establishing a database connection: undefined constant DB_USER
  68. Add pdf to a website
  69. Optimizing function that automatically creates internal links based on post title string
  70. Outputting query results
  71. Help With a Large WordPress Based MySQL Database on Shared Hosting
  72. WordPress where clauses in db select
  73. Can two domains use the same database?
  74. _wp_attachment_metadata is not being added to database when PDF files uploaded
  75. adding user_id and name to a separate table whenever a user register based on role
  76. How do I loop/iterate through posts to edit all img tags?
  77. User saved through WordPress backend does not show up in database table users
  78. How to edit posts/pages without making the change live?
  79. Correct and secure way to access a custom SQL database in a custom PHP template file
  80. How to optimise this database query?
  81. How to retrieve user data based on role using SQL?
  82. Adding featured for post using database
  83. Does WordPress Support Using Named Pipes on the Windows Operating System?
  84. get_the_terms is not working
  85. Store id from database query in cookie
  86. Split database on large site?
  87. Store the wordpress “featured image” under »wp_posts« Database table
  88. Custom metabox does not store data
  89. Return image urls with specific base string?
  90. What WordPress file is saving new users to database
  91. wordpress database error
  92. How do i get value from wp_postmeta?
  93. Link to handle $_GET request
  94. WordPress sync with phpbb
  95. featured image not showing up with mysql_connect
  96. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  97. wp_usermeta key problem
  98. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
  99. Database Queries are crashing the server
  100. Uploading to WordPress Database