Clear WordPress Records

Open

Open in GitHubOpen in ChatGPTOpen in Claude

Delete Media Files Data

Sometime you want to delete only the database records

Each file in your media library has one row in the wp_posts table and two rows in the wp_postmeta table.

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";

Delete MainWP Records

DELETE FROM `wp_options` where option_name like '%mainwp_%'