vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Reset database? (https://vborg.vbsupport.ru/showthread.php?t=48018)

sk187 01-23-2003 01:59 AM
Reset database?
 
Ive looked around and cant seem to find anything.

I have a board thats been around for years and over that time its been upgraded from ubb to phpbb to vbb and then several vbb upgrades and I added a portal.

I want to install a fresh copy of vbb and put all my users/posts/ext back into the new vbb. However after all the hacks and edits over the years my database is pretty mangaled. I want to keep everything but remove anything in the database that insnt suposed to be there. I dont want to have 4,000+ members re-register.

Anyone know what I mean?

Thanks in advance,
sk

mr e 01-23-2003 03:04 AM
in your forums admin's cp, backup the database, then in your site's control panel create a new database and upload your mysql backup

sk187 01-23-2003 03:25 AM
Well i want the actual tables of the database brought back to stock. Over the years new fields have been added in the tables and so on. I want to keep my current data but remove all new fields from tables in the database.

For example some hacks modify a table in the database - i need somthing to remove it and take out all those new fields that have been added over time.

This is hard to explain sorry.

Xenon 01-23-2003 09:34 AM
well just manually possible.
download the DB sheme of vb in the membersarea, and then got through the tables with phpmyadmin and delete all unneeded field


All times are GMT. The time now is 01:37 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.01695 seconds
  • Memory Usage 1,706KB
  • 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
  • (4)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