vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   I can't restore my database backup, need some suggestions? (https://vborg.vbsupport.ru/showthread.php?t=239422)

James T Brock 03-30-2010 04:12 PM

I can't restore my database backup, need some suggestions?
 
I have a very large forum, the database is 5gigs+ and we have over 2 million posts. I am currently using vB version 3.6.

I have been trying to mirror my forum on a test server so that I can upgrade it to version 3.8 before doing the same on my "live" site however I have been unable to restore the database. I have tried on three different servers and on each server I get the exact same problem. I perform the restore process using SSH like I have always done but each time the restore process gets to the "postindex" table and stops.

The postindex table on the live server is 1.8gigabyte but on the test servers it only imports 161.2 MiB before stopping.

Why is this happening? Is my database corrupt?

--------------- Added [DATE]1269969241[/DATE] at [TIME]1269969241[/TIME] ---------------

Second question... does anyone know how to run a "repair" on an .sql file? I know how to repair a database that is already loaded into mysql but what about the individual backup file sitting on your server?


All times are GMT. The time now is 08:34 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.01033 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