• 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

    Ask a Question: Cancel reply

    Your email address will not be published. Required fields are marked *

    9 − four =

     

    PUBG Mobile Tips & Tricks

    free fire how to play (a-z guide) guns, tips & tricks etc

    Windows 10 tips & tricks

    Pagespeed optimization

    Pc building tips & tricks

    nginx server tutorials

    apache server tutorials

    linux sysadmin tutorials

    mysql Commands list pdf

    Android studio tutorials

    Gaming/ streaming tips

    Airtel dth channel list

     

    wordpress tutorials for beginners advanced complete guide to run WordPress

    • Wordpress errors and fix
    • 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
    • website cache best caching plugins wordpress w3tc cloudflare
    • Rules to get 100/100 in Google pagespeed insights score
    • Install xamp & wordpress on localhost windows
    • Change / Add / Disable favicon in wordpress Ft Genesis Theme or any theme
    • recommended php memory limit for wordpress (which one) 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 2021 #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 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 2021 - 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 via command line apache nginx ubuntu debian
    • Top 3+ Wordpress Security Plugins 2020 (Brute force, Login lockdown, Malware scanner etc)

    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

    © 2021 - All Rights Reserved Disclaimer & Privacy Policy