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)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Restoring Using BigDump (https://vborg.vbsupport.ru/showthread.php?t=307852)

TheInsaneManiac 02-03-2014 06:53 AM
Restoring Using BigDump
 
Just upgraded to CentOS 6 and I am having a problem with restoring database. Even tried big dump. All I get is this lonnnnng error message.
Code:
BigDump: Staggered MySQL Dump Importer v0.35b
Processing file: cdiscuss_vbulletindb.sql
Starting from line: 1

Error at the line 5797: INSERT INTO `vb_language` (`languageid`, `title`, `userselect`, `options`, `languagecode`, `charset`, `imagesoverride`, `dateoverride`, `timeoverride`, `registereddateoverride`, `calformat1override`, `calformat2override`, `logdateoverride`, `locale`, `decimalsep`, `thousandsep`, `phrasegroup_global`, `phrasegroup_cpglobal`, `phrasegroup_cppermission`, `phrasegroup_forum`, `phrasegroup_calendar`, `phrasegroup_attachment_image`, `phrasegroup_style`, `phrasegroup_logging`, `phrasegroup_cphome`, `phrasegroup_promotion`, `phrasegroup_user`, `phrasegroup_help_faq`, `phrasegroup_sql`, `phrasegroup_subscription`, `phrasegroup_language`, `phrasegroup_bbcode`, `phrasegroup_stats`, `phrasegroup_diagnostic`, `phrasegroup_maintenance`, `phrasegroup_profilefield`, `phrasegroup_thread`, `phrasegroup_timezone`, `phrasegroup_banning`, `phrasegroup_reputation`, `phrasegroup_wol`, `phrasegroup_threadmanage`, `phrasegroup_pm`, `phrasegroup_cpuser`, `phrasegroup_accessmask`, `phrasegroup_cron`, `phrasegroup_moderator`, `phrasegroup_cpoption`, `phrasegroup_cprank`, `phrasegroup_cpusergroup`, `phrasegroup_holiday`, `phrasegroup_posting`, `phrasegroup_poll`, `phrasegroup_fronthelp`, `phrasegroup_register`, `phrasegroup_search`, `phrasegroup_showthread`, `phrasegroup_postbit`, `phrasegroup_forumdisplay`, `phrasegroup_messaging`, `phrasegroup_inlinemod`, `phrasegroup_plugins`, `phrasegroup_cprofilefield`, `phrasegroup_reputationlevel`, `phrasegroup_infraction`, `phrasegroup_infractionlevel`, `phrasegroup_adv_portal`, `phrasegroup_adv_portal_cp`, `phrasegroup_prefix`, `phrasegroup_socialgroups`, `phrasegroup_prefixadmin`, `phrasegroup_notice`, `phrasegroup_album`, `phrasegroup_vbbux_admin`, `phrasegroup_vbplaza_admin`, `phrasegroup_vbshout`, `phrasegroup_tagscategories`, `phrasegroup_contenttypes`, `phrasegroup_advertising`, `phrasegroup_vbblock`, `phrasegroup_vbblocksettings`, `phrasegroup_vbblogadmin`, `phrasegroup_vbblogcat`, `phrasegroup_vbblogglobal`, `phrasegroup_cpcms`, `phrasegroup_vbcms`, `phrasegroup_widgettypes`, `phrasegroup_downloads2`, `phrasegroup_dl2admin`, `phrasegroup_evbs_sstab`, `phrasegroup_v3arcade`, `phrasegroup_v3arcade_admin`, `phrasegroupinfo`, `phrasegroup_ckeditor`, `phrasegroup_activitystream`, `phrasegroup_dbtech_usertag`, `

RichieBoy67 02-03-2014 02:45 PM
You tried ssh?

Zachery 02-03-2014 06:29 PM
You should be restoring backups via ssh, not bigdump, if you have any way to access ssh, or someone else does.

TheInsaneManiac 02-04-2014 12:47 AM
ERROR 2006 (HY000) at line 5797: MySQL server has gone away

RichieBoy67 02-04-2014 12:58 AM
I think you need to increase your max_allowed_packet size in my.cnf - Still I would use ssh. if you have an issue using ssh you can just start from where you left off. You may still need to increase your packet size though.

ozzy47 02-04-2014 12:59 AM
MySQL server has gone away is a host issue, see this post:

http://www.vbulletin.com/forum/forum...rror-explained

RichieBoy67 02-04-2014 01:05 AM
Yeah, if on a shared host you may have issues with the packet size, not being able to change it. Before exporting make sure you have attachments, etc stored in the file system and not the database.

If you are not shared then just edit my.cnf and increase packet size which is most likely the issue though it could be time out.

you can also change the config in bigdump to decrease the amount of tables it processes at a time if you still want to try using it.

TheInsaneManiac 02-04-2014 01:35 AM
I already reprovisioned my server. I seem to be able to login an everything but I keep getting emails about session table not existing. I also have a ton of depreciation errors since upgrading my server to CentOS 6

consolediscussions.com/forum

Any idea what's going on here?

RichieBoy67 02-04-2014 02:33 AM
For the depreciation errors just download the class_core.php file from Vbulletin. The latest has the fix for those.

For the session table it seems likely that it did not get imported. Try to reimport it and then do an mysql repair.

Zachery 02-04-2014 05:58 AM
Recreate it, or just truncate the session table, if its there in a bad state.


All times are GMT. The time now is 05:27 AM.
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.01020 seconds
  • Memory Usage 1,738KB
  • 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)bbcode_code_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