WordPress – delete all media files

To delete the media files without leaving traces in the database, do the following:

  1. Connect to the mysql database – using phpmyadmin, for example – and run the following queries:
    DELETE FROM wp_postmeta WHERE post_id IN ( SELECT id FROM wp_posts WHERE post_type = ‘attachment’ ) ; DELETE FROM wp_posts WHERE post_type = ‘attachment’;
  2. Delete the files and folders stored in ./wp-content/uploads/
Tags