View Single Post
  #6  
Old 12-20-2002, 09:40 PM
tHE DSS's Avatar
tHE DSS tHE DSS is offline
 
Join Date: Jun 2002
Location: UK
Posts: 113
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I see what you need.

You need this :

http://www.scibit.com/Products/Softw...ils/Mascon.htm



... try out the Freeware version... see if you like it... if you do, you'll have to pay for the full version to be able to put your backup databases back.

At only $49, it's a bloody bargain!!!

With that, you wouldn't even need a backup. You could just make a copy from one server, and dump it directly to the other. Sweet as a nut!!

I was pointed to that utility because our forums database got too large for the vB Admin CP to handle, and we don't have Telnet access to our webserver.

With this application, I can manipulate our database fully.... I can even get rid of the potential security problem of using phpMyAdmin from the web server. :devious:

One thing though.... you will need to go through the vB database structure, and change any fields that are set to NOT NULL, to NULL... as some fields in some records will be blank, even though they shouldn't have NULL values.

When importing a database, you'll notice that it will halt part the way through, due to that error cropping up.

You can always go back and set the NULL fields back to NOT NULL when you've properly imported.

That shoud only affect fields that accept alphanumeric data though. Not INTEGER, and such.

Another thing.... DO NOT EVER set the program to CONTINUE ON ERRORS... because it will continue, but you won't have a complete database.

Anyway... that's what you are looking for. I am 100% you will be happy with it. I am.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01109 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (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_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete