vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=189)
-   -   [Resource] BIG Sql Dumping (https://vborg.vbsupport.ru/showthread.php?t=77148)

Zero Tolerance 02-26-2005 10:00 PM

[Resource] BIG Sql Dumping
 
I'm sure many have come across the annoying timeout's that phpMyAdmin give's when trying to import a large SQL dump, and you think all hope is lost when your trying to restore for example your forum database.

One alternative is Telnet/SSH/Shell, however not all hosts give users access to use this tool for numerous security reasons, so what can you do?

Here is an extremely useful tool to import large SQL dumps: http://www.ozerov.de/bigdump.php

Unlike phpMyAdmin, which tries to import everything at once (eat the pizza in one), this script will execute parts of the dump and then move onto the next part (eating one slice at a time), untill the script has fully completed.

I personally have used this script recently when moving servers, no data was lost, and no timeouts were given. I recommend it to those who need something to import large database dumps, it did the job for me :)

- Zero Tolerance


All times are GMT. The time now is 07:21 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.01147 seconds
  • Memory Usage 1,701KB
  • 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
  • (1)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