Topic: How do I delete all users and posts from the databace?
How do I delete all users and posts from the databace?
2 2008-10-27 23:30 (edited by User33 2008-10-27 23:31)
Re: How do I delete all users and posts from the databace?
You could delete 'config.php' on your PunBB installation folder then visit 'index.php'. Now, it should ask you to "Install" PunBB again. When entering your database info, just choose a different prefix for your MySQL tables (the default is 'punbb_').
I hope this helped.
Re: How do I delete all users and posts from the databace?
Do you mean you want to keep categories/forums/configuration?
marcusw wrote:
How do I delete all users and posts from the databace?
You must be also including topics to this list.
To do exactly this in PunBB 1.2, you need:
1. Clear the tables (DELETE FROM <prefix><table>;):
- posts
- topics
- users
- bans
- reports
- all search_* tables
- subscriptions,
2. Clear all last_* fields in forums table (UPDATE <prefix>forums SET <field> = NULL;).
PS: Do not forget to dump the database before any operations like this.
Carpe diem