vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Stripping down? (https://vborg.vbsupport.ru/showthread.php?t=213394)

oldfan 05-11-2009 12:55 PM
Stripping down?
 
Sorry if this is the wrong forum to ask this question...

Our forums/database is about 7 years old and I've lost track if what mods and modifications I've done over the years. Its a really bloody mess and I'd like to start of fresh and keep better tads on it this time.

I know you can transfer posts, threads and users, but will all the db tables/fields be reset to default? I don't want my users to have to re-register if they don't have to.

thanks

Biker_GA 05-11-2009 12:58 PM
As far as I know, there's no way to easily import the default tables/data into a new DB. You basically have to go through the DB and manually drop the tables that don't apply to your installation any longer. Something that's been on my "To Do" list for some time now.

Cryo 05-11-2009 01:05 PM
Do you want to completely get rid of all the tables and start with fresh ones? If you're upgrading from a previous version of vB it should just be a simple matter of upgrading and the installer will take care of the rest. If you want to start with completely fresh tables you should look at the vB importer. I'm pretty sure this will take source data from your existing tables and copy it correctly into the new installation / tables.

If you're just upgrading you can start fresh with a new style and system files and not worry about any past modifications. Granted, you may have some useless entries in your tables, but they won't be used so it should have virtually no effect on the speed of queries.

oldfan 05-11-2009 01:41 PM
Quote:
Do you want to completely get rid of all the tables and start with fresh ones?
yes

Fresh everything along with software upgrade, I just want to transfer posts, threads and users, minus all the modications I've added over the years.

Biker_GA 05-11-2009 01:45 PM
I asked the same question not too long ago. ;)

oldfan 05-11-2009 01:57 PM
Quote:
Originally Posted by Biker_GA (Post 1808671)
I asked the same question not too long ago. ;)
oh man :(

Quote:
Database hacks. You need to use a program like phpmyadmin to browse your database and remove custom tables and fields.
How do I know which ones I can remove and not to remove ?

Biker_GA 05-11-2009 02:02 PM
Heh.. There's the rub. There are version numbers associated with the tables, so much of it is an easy no brainer (I have tables from version 2.0!). The easiest way, I guess would be to print out the table structure for a "virgin" install and compare it to the existing one.

oldfan 05-11-2009 02:16 PM
Quote:
Another option is to import your database into a fresh installation of vBulletin. I recommend this only as a last resort if the database is unusable and you don't have a working backup. The import doesn't get everything and there are side effects. For example, the autoincrementids are not preserved so all previous internal links and bookmarks will be broken.
Whats the chances this would happen?

Biker_GA 05-11-2009 02:18 PM
100%. As Jake stated, it's a "last resort" item done in desperation. I'm not willing to break everything in old posts.

Lynne 05-11-2009 02:39 PM
Quote:
Originally Posted by oldfan (Post 1808683)
How do I know which ones I can remove and not to remove ?
You may be interested in this modification - Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin

Remember that you should do this first on a test site, not your live site.


All times are GMT. The time now is 10:25 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01712 seconds
  • Memory Usage 1,736KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete