You should also check .
wp_postmeta (custom fields for each post, etc.)
wp_term_relationships (categories / terms associated to a post)
wp_comments (comments data)
wp_commentmeta (comments data)
Rajesh,
By “check” do You Mean I should run a SQL delete date-specific query on those tables as well?
Since comments may cross over the date threshold I have set (01.01.2013) from the date of the original post, what field in those table should I run the query against?
Thank you for your help.
By “check” do You Mean I should run a SQL delete date-specific query on those tables as well?
Ideally, you should perform an inter-table join (on the Post ID).
Date-specific query to be applicable only on the wp_posts table.
I looked at the structures of:
wp_postmeta
wp_term_relationships
wp_comments
wp_commentmeta
and only wp_postmeta has a field for post_id
I also looked for plugin to accomplish this task and came up short on anything with enough history to assure me I couldn’t or wouldn’t screw this up.
I am not familiar enough with the inner join syntax to put a query together that will safely delete posts based on a date range, specifically all posts before 01.01.2013
I hate asking for someone to hold my hand on this but I’m flipping the switch on this move tomorrow night and am pressed for time.
Help anyone?
Thanks
I’m an unpaid, and dare I say POOR blogger. I can’t afford to hire someone to create a sql query but thanks anyway.
I also looked for plugin to accomplish this task and came up short on anything with enough history to assure me I couldn’t or wouldn’t screw this up.
This is one situation where that actually doesn’t matter (and that’s only because you have a backup of your database).
You have a complete database back up. This means that you can try any of these plugins, and test to see if they work without breaking stuff. If they work, then great. If they don’t work then you just restore your databse from your backup and try the next one. All it will take from you is a bit of time.
