How to delete all media at once in wordpress?

Question

WordPress

There are more than 350k media on the site, we removed them from the uploads folder, but they remained in the wodrpress control panel. How to remove them all at once?

Answer 1

DELETE FROM `wp_posts` WHERE `post_type` = "attachment";
DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attached_file";
DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attachment_metadata";
These 3 queries against the database will remove all master media records, unless they created some custom fields for the images.