• Home
  • WordPress
  • web Hosting
    • Free hosting
    • Cheap Hosting
    • comparison cloud , vps, shared, wordpress
    • managed wordpress hosting
    • managed cloud hosting
  • page Speed
  • Deals
  • Services
  • About

RAaz Kumar .com

wordpress tutorials seo hosting etc


How to bulk delete in wordpress posts, pages, Media Images, tags and categories

How to bulk delete in wordpress posts, pages, Media Images, tags and categories

bulk delete wordpress media Images  from database

go to phpmyadmin and locate your database run sql query below by click sql paste this code one by one.

  1. # First:
  2. DELETE FROM wp_postmeta
  3. WHERE post_id IN
  4. (
  5. SELECT id
  6. FROM wp_posts
  7. WHERE post_type = ‘attachment’
  8. )
  9. ;
  10. # Second:
  11. DELETE FROM wp_posts WHERE post_type = ‘attachment’

How to delete only Unattached wordpress mediafiles?

 Really I don’t Know How to identify Unattached and attached media.
These Media attachments are like post or pages. so

How i deleted unattached media files in from wordpress database?

i tried to delete wordpress attachments from wordpress media dashboard but i am able to delete only 22 attachments at a time. but there are more than 2700 attachments which are imported from blogger/ blogspot image while i am moving blogger wordpress in the year 2012.
also there is a issued wp-post meta data also same as blogger when the wordpress updates sometime old permalinks will appears. and guid also as blogger permalink. we need fix this.
let’s go to the point 
Go sql query in phpmyadmin enter this code 
  1. DELETE FROM wp_posts WHERE post_type = ‘attachment’

choose modified date Ascending order or Descending order increase the rows to view 25 to 500 .also check post title while you are deleting the attachments.

That’s I did. i tried wp-media cleaner plugin not worked.

How to bulk delete posts,pages, tags in wordpress?


If you want delete bulk posts, pages, tags, categories use wp-mass delete or bulk delete plugin.


delete post meta data from database which is unused?

simply run this query

below this will delete unused post meta data from wordpress database thorough phpmyadmin.


DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL;



Delete All tags in wordpress

We can delete by sql query also from these 2 other plugins.

delete unused tags plugin updated on 2013

My blog have 2.203 tags I want to delete all of them. but below 2nd mass delete plugin may cause problem with wordpress.just faced functions.php error with wordpress managed hosting godaddy.
mass-delete-unused-tags download

Finally i have used unused tags wp plugin and deleted all wp tags of unattached now i am only have 857 tags. which are not indexed by google. know more about tags & categories with google.
Mass delete tags plugin not updated from 2 years.also not compatible with present version wordpress.


Also look at wordpress duplicate content

Note use this Carefully and backup your database before this.

    Related topics:

    1. WordPress database optimization (don’t neglect) plugins & phpmyadmin manually
    2. WordPress duplicate thin content Issues {FIXED}
    3. How to use wordpress tags and categories
    4. wordpress tutorials for beginners advanced complete guide to run WordPress
    5. Auto post to Facebook, twitter, Google Plus WordPress Posts 2019

    wordpress tutorials for beginners advanced complete guide to run WordPress

    • Rules to get 100/100 in Google pagespeed web core vitalsscore
    • How to add adsense amp ads to wordpress
    • wordpress password reset in 3 ways mail, phpmyadmin, mysql command
    • how i recovered hacked website site 5 times ft wordpress?
    • enable browser caching in wordpress apache nginx caching headers explained
    • W3TC w3 total cache plugin setup guide review comparison with wp rocket and wp super cache
    • Wordpress database optimization (don't neglect) plugins & phpmyadmin manually
    • Optimize css delivery inline critical css, remove unused css, render blocking css
    • Converting WordPress into static website speed after 1 second dynamic 3 seconds
    • Wordpress errors and fix
    • website cache best caching plugins wordpress w3tc cloudflare
    • Install xamp & wordpress on localhost windows
    • favicon ico Change / Add / Disable favicon in wordpress Ft Genesis Theme or any theme
    • increase wordpress memory limit (how to ) 40MB , 64 MB 128 MB or 512 MB maybe 1024MB
    • wp cron job check working or not disable enable change schedule
    • google analytics plugins for wordpress #sitekit #monsterinsights gadwp back as gainwp
    • Lazy Load Adsense to improve core web vitals - Vs revenue
    • xmlrpc php wordpress uses, disable without 403 error log message
    • wordpress change post date programmatically (auto on update like blogger
    • wordpress plugins that slow down your site and its alternatives
    • best wordpress plugins social, seo, Backup, speed up your blog
    • TOP 10 Wordpress Themes Premium/ Free & providers
    • Wordpress Adsense Plugins & Manually
    • Social share buttons for website Wordpress Blogger
    • How to bulk delete in wordpress posts, pages, Media Images, tags and categories
    • TOP 5 Best wordpress comment plugins 2020 (disable pingback, replytocom, customize form)
    • all in one seo pack vs yoast seo pressor
    • Auto post to Facebook, twitter, Google Plus Wordpress Posts 2019
    • wordpress speed optimization Speed up wordpress Score on Google pagespeed
    • How to use wordpress tags and categories
    • Wordpress duplicate thin content Issues {FIXED}
    • how to increase wordpress memory & file upload size
    • combine rss feeds wordpress
    • Reduce the impact of third-party code ,optimize JS delivery, Minify, remove unused js, pre connect, inline, lazy load etc
    • change wordpress site url
    • install wordpress on ubuntu apache nginx debian command line
    • Wordpress Security Plugins 2021 (Brute force, Login lockdown, Malware scanner etc)

     

     

    wordpress Pagespeed optimization

    Digitalocean free $100 Credit

    Cloudways Review pricing promo codes

    Siteground cpu limits Pricing

    Shared Hosting

    Managed wordpress Hosting

    Managed Hosting Cloud server

    VPS Hosting

    Cloud Hosting – Unmanaged

    Google cloud Pricing

    Aws Pricing

    Azure pricing

    nginx server tutorials

    apache server tutorials

    linux sysadmin tutorials

    mysql Commands list pdf

    LEMP Install Ubuntu

    Mysql Performance Tuning

    Nginx Performance tuning

    Linux Performance tuning

    Php -fpm performance tuning

    Redis Performance tuning

    linux server security

    nginx security best practices

    wordpress security plugins

     

     

    wordpress

     

    Top 5  WP Google Analytics Plugins

    WP Backup Plugins

    Wp Comment Plugins

    Top wordpress Security Plugins

    WP Seo Plugins

    WP Caching Plugins

    Best Adsense Plugins for WordPress

    Wp social Sharing Plugins

    autoshare social media plugins

    WP speed Optimization Plugins

    Speedup WordPress google Score

    More Wp tuts

    Server Admin Cloud

     

    Installing Nginx LEMP On ubuntu

    Installing apache Lamp ubuntu

    nginx fastcgi cache enable

    php – fpm install  & Configuration

    Opcache install & Configure

    php -fpm pool manager explained

    Mysql Install & Configuration

    Redis Object cache install & configure

     

    Nginx as Reverse Proxy and Load balancer

    Load Balance / auto scaling in google cloud

    Linux Commands PDF

    Mysql Commands Pdf

    Letsencrypt tutorial

    mysqldump export & import 

    Pagespeed Module install & configure

    nginx.conf best file

    mysql.conf best file

    upgrade ubuntu

    © 2023 - All Rights Reserved Disclaimer & Privacy Policy