Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Nov 2010, 07:40
Areku Areku is offline
 
Join Date: Feb 2002
How to empty forums (and reset ids)

Hi!

we've been testing a few hacks and mods onto a test vb which now can go live.

is there a way to EMPTY posts / users (except the admin) and at the same time "start from scratch" like if the forums were brand new? (ie. first post will get postid=1, threadid=1, second user registered besides admin will get userid=2, etc)?

Just for posts and users. Forums, templates, styles, languages, remain as they're currently.

Thanks!
Reply With Quote
  #2  
Old 19 Nov 2010, 14:52
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
There is no vbulletin function to do this. You could try deleting them all via vbulletin (users and posts) and then resetting the auto_increment property for the tables in the database. But, if you don't delete everything, and don't reset them all, then you could cause problems. I'd suggest if you are going to do this, you do so on a test site and take notes on what you did so you can do it right on the live site.

Templates/Styles/Languages can all just be exported and then imported to the new site. Forums cannot, unfortunately.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 19 Nov 2010, 15:03
Areku Areku is offline
 
Join Date: Feb 2002
What about phpmyadmin? is there a way to reset the forums by executing the "empty" command only certain tables and reset the auto_increment, while running some update counters or whatever?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:36.

Layout Options | Width: Wide Color: