delete 1000 articles?

I have been using spip as system, for a while.
Now I see it holds around 4500 articles.
Anybody have a good idea, how to delete the first 1000 articles or more?
Do i have to do this manually..?
kindly
Tom

I suggest you to use you mysql manager ( like phpMyAdmin ).
This SQL query can be enough :
"DELETE FROM spip_articles WHERE id_article<1000"
or better (less destructive)
"UPDATE spip_articles SET statut = 'poubelle' WHERE id_article < 1000"
(you can also remove the elements from the join tables, but I think
that it isn't necessary)

The main pb is that the documents that where attached to your old
articles are not remove from your server.. I actually doen't know if a
plugin automatically does this job.

You can also use the plugin "archivage" but I actually don't know it
very well, so I can't tell you if it's really simple to use or not.

.Gilles

On Sun, Mar 30, 2008 at 3:00 PM, tom@mir2.dk <tom@mir2.dk> wrote:

I have been using spip as system, for a while.
Now I see it holds around 4500 articles.
Anybody have a good idea, how to delete the first 1000 articles or more?
Do i have to do this manually..?
kindly
Tom

_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en