Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • bayshield 50 posts 65 karma points
    Oct 24, 2010 @ 16:37
    bayshield
    0

    Deleting 30k+ content nodes

    I have written an app that programmatically creates content nodes of a particular docType in umbraco.  I now need to delete approximately 30,000 nodes and recreate them.  Ideally, I would just like to run an SQL statement to delete them from the DB.  Does anyone have an sql statement to do this?  

    I was considering using an API call, however I would like to avoid the trash can all together.

    Thanks,

    Aaron

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Oct 25, 2010 @ 08:46
    Richard Soeteman
    0

    You can dowload the source of the Content Maintenance Dashboard package. It queries the database using sql and then tweek the code a bit to delete the document also from recyle bin

    Or follow the instructions in  this post (make a backup)

    Cheers,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft