Confluence Command Line Interface can be used without taking Confluence offline or worrying about corrupting your database. Use the query in runFromSql. An alternative for OnDemand or if you don't want to do SQL is to use getBlogList to a csv file and a small script to select rows by date. In either case, use something like:
--action removeContent --id nnnnnnnn
Matthew's answer can be used indeed. A script can be created to delete blogposts, however, note that the blogposts are inside the "content" table and this table consists of multiple FKs in the database. So, if you are willing to create a script, be sure to not violate any constraint in the process and keep the database clean.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs