vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Start anew with all posts? (https://vborg.vbsupport.ru/showthread.php?t=48836)

Sefiros 02-12-2003 03:18 PM

Start anew with all posts?
 
Well, you see, my situation is that I want to take my forums down for the anniversary of my site to upgrade the forums.

I want to delete all files, then install 2.2.9 and then import the needed databases, but only for posts and forums. I just don't know which I have to import. So I thought you guys could maybe help me?

Thank you for your precious time.

:banana:

Xenon 02-12-2003 04:29 PM

you have to make a dump of forum, thread and post table.
then run a query to set all post userid's = 0

but then all posts would have guest status.
the other possibility is to save also the user fields...

Sefiros 02-12-2003 09:08 PM

So a new install and then only import 'forum','thread','post' and 'user'?

That's all? Nothing running around in some other tables? ;)

Xenon 02-12-2003 09:59 PM

if you import the users, you also have to import userfield and usergroup table :)

TECK 02-13-2003 12:04 AM

As well the attachment, avatar, customavatar, forumpermission, moderator, poll, pollvote, profilefield, threadrate (if enabled) and usertitle (if you use custom titles).

The best way is to simply import the hole tables and drop them on a test board first, just to make sure you don't kill your database.

Xenon 02-13-2003 11:40 AM

hmm that's not exactly right Floren. you know you could just reset all the attachments/titles and avatars/vote things...

so really neede are just the one i posted :)


All times are GMT. The time now is 01:40 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01139 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete