Sign in Register
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

    Copy Link
  • Richard Soeteman 3875 posts 12037 karma points MVP
    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

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies