Restoring Using BigDump

[TheInsaneManiac]

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.

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]

You tried ssh?

[Zachery]

You should be restoring backups via ssh, not bigdump, if you have any way to access ssh, or someone else does.

[TheInsaneManiac]

ERROR 2006 (HY000) at line 5797: MySQL server has gone away

[RichieBoy67]

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]

MySQL server has gone away is a host issue, see this post:

http://www.vbulletin.com/forum/forum/vbulletin-legacy-versions-products/legacy-vbulletin-versions/vbulletin-2-how-do-i-and-troubleshooting/44661-mysql-server-gone-away-error-explained

[RichieBoy67]

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]

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]

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]

Recreate it, or just truncate the session table, if its there in a bad state.

[RichieBoy67]

Recreate it, or just truncate the session table, if its there in a bad state.

Yeah, no need to reimport the session table. :)