Top Poster
#1 ramon fincken 403
#2 Site admin 3
#3 Ber|Art 2
#4 braddmark 1
#5 accentmedia 1
#6 Xarzu 1
#7 khadish 1
#8 moxxx 1
#9 nistelrock 1
#10 Justin-ServerPilot 1
wp-cli delete all with custom keep-me table



Rating : 3 / 5

Tags:

 
Post new topic   Reply to topic    Ramonfincken.com Forum Index -> CMS-ses (Joomla, WordPress, etc..)
Beta
Want to be notified by email when this topic gets a reply?  
View previous topic  
Author Message
ramon fincken
Site's programmer

Get a free globally recognized avatar
It's free!

Joined: 03 Aug 2007
Posts: 403
Location: A'dam/Diemen, The Netherlands
PostPosted: Mon Jan 18, 2021 7:06 pm    Post subject: wp-cli delete all with custom keep-me table Reply with quote
Code:
wp-cli post delete $(wp-cli db query --socket=/usr/local/mysql/data/mysql.sock --skip-column-names --batch "SELECT post_id FROM wp_postmeta WHERE post_id < 1010313 AND post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'attachment' AND ID NOT IN ( SELECT meta_value FROM wp_found ) ) AND meta_key = '_wp_attached_file' LIMIT 200") --force


you need a limit if you expect many thousands of IDS, this is due to a bash limit, not your WP site or the DB

use at your own risk, this is more complex than you might think!
Back to top
View user's profile Send private message Visit poster's website
Google adsense
Advertisement
PostPosted: Mon Jan 18, 2021 7:06 pm    Post subject: wp-cli delete all with custom keep-me table
Advertisement
Back to top
GravityForms
Advertisement
PostPosted: Mon Jan 18, 2021 7:06 pm    Post subject: wp-cli delete all with custom keep-me table
Advertisement
Gravity Forms Plugin for WordPress
Back to top
Post new topic   Reply to topic    Ramonfincken.com Forum Index -> CMS-ses (Joomla, WordPress, etc..) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
General forums
The world of freelance
Programming
Other projects
Poll
I love gifts

Yes goodies and presents! [3]
No but I love polls ! [1]
Related google ads