Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 06-20-2005, 11:53 PM
JazzleBug JazzleBug is offline
 
Join Date: Feb 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Inserting specific data and ignoring the rest.

I'm trying to clean up my database. Ultimately, what I'd like to do is install clean software with a clean database, resinstall only the hacks I desperately need (which happen to have quite a bit of extra data to be imported), insert the necessary data, and end up with no orphaned tables or unused data.

More specifically where the database is concerned, after all of my hacks are installed on the clean software (complete with database modifications), I need to insert only the data that will fit into the new tables and simply ignore anything left over (unused/orphaned data/tables).

Further explaination needed? FYI, I use SSH primarily due to the large community size.

Please, if anyone can offer any guidance on this, I'd be more than appreciative. I've been banging my head on my desk for the past day and a half trying to work this out.
Reply With Quote
  #2  
Old 06-20-2005, 11:58 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do a vB3->vB3 import with Impex and you'll have a clean database.
Or compare the scheme off all your tables to a blank installation and drop what you don't need anymore - this should alos result in a clean database (but there might be orphaned settings/phrases/templates then which still need to be killed manually).

How large is your community?
Reply With Quote
  #3  
Old 06-21-2005, 12:16 AM
JazzleBug JazzleBug is offline
 
Join Date: Feb 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The database is 532 MB. I've played around with ImpEx a bit, but that leaves the added database tables out and I'll still need to insert that data. Which, actually, wouldn't be so hard except that I'm looking for the fastest, easiest way to do this, preferably with a few commands. Something that would essentially allow the data that fit to filter on in and the rest would be ignored.

If only life were so easy. Thank you for your quick response.
Reply With Quote
  #4  
Old 06-21-2005, 12:19 AM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well as there are (and probably never will be) filters for hacks data you are left to cleaning your database manually.
522 MB isn't that much, so it sounds doable.
Reply With Quote
  #5  
Old 06-21-2005, 12:25 AM
JazzleBug JazzleBug is offline
 
Join Date: Feb 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fortunately, you're right - it's not that big, so manually is probably my best bet. Thank you, Kirby.
Reply With Quote
Reply

Thread Tools
Display Modes

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

Forum Jump


All times are GMT. The time now is 12:59 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03889 seconds
  • Memory Usage 2,186KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete