By bassio on

I want to delete all nodes and start clean. For switching from a local test environment to a live site.

What are the steps?

I know there are the sequences table numbering and there are also these pesky cck fields and content types.

Which tables to empty, which to keep?

⋅ Categories: Drupal 5.x

Comments

karna’s picture

karna commented

If you use CCK and other fancy nodes you really need to know which tables are used to store what, you cannot just truncate the node table.

I would recommend you delete the nodes through the administrative interface (Administer > Content Management > Content) and let Drupal figure out for you how to actually delete the nodes. You can delete multiple nodes at a time with this interface, thus this should not be too time consuming.

Hope this helps..

--------
F.J. Jungen
www.boria.nl

bassio’s picture

bassio commented

Thanks .. I will also have to check the sequences table to reset some ids.

Any other point that is missing?

andydev’s picture

andydev commented

It would be a good idea to have a 'Clean Content' Option in CCK and drupal.

summit’s picture

summit commented

Hi,

I also want to start a new site with a clean sheet. But I already have a site with the functionality I want. I just want to delete the nodes, taxonomy terms, blocks and url-aliases. I use cck so just deleting the nodes, taxonomy, blocks and url-aliase tables is not enough.

For drupal 4.6 there was the massdelete module (http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/massdelete/).
For drupal 4.7 I saw Khalid made a module deleteall (http://2bits.com/software/utility-delete-all-nodes-in-a-site.html). I asked him if he would like to update to 5 :)
But is there a mass delete all module for Drupal 5 already please? Or has someone already updated the massdelete or deleteall module for drupal 5?

Otherwise I have to go into my database and have a time-consuming process of deleting tables and records..
Thanks in advance for your reply!

Greetings,
Martijn