Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-27-2009, 04:32 PM
IR15H IR15H is offline
 
Join Date: Feb 2007
Location: England
Posts: 161
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL troubles

To cut a long story short; my site crashed and my sql back up didn't work.

I'm running vB 3.8.3, Apache 2.2.11, PHP 5.2.9-2 and MySQl 5.1.33 (which I downloaded as a WAMP bundle) and using MySQL Admin 5.1. I remote desktop to the machine, which is running Windows Server 2003. I've disabled all plugins by putting define('DISABLE_HOOKS', true); in my config.

When I try a restore via MySQl Admin I get the following error;
Quote:
Error while executing this query:INSERT INTO `customavatar` (`userid`,`filedata`,`dateline`,`filename`,`visibl e`,`filesize`,`width`,`height`,`filedata_thumb`,`w idth_thumb`,`height_thumb`) VALUES ...LOADS OF NUMBERS...
The server has returned this error message:MySQL server has gone away
MySQL Error.
I tried altering my.ini to max_allowed_packet = 256M but that didn't help. Unfortunately, this is the case for all my manual back ups going back 6 months .


I did manage to copy the info from mysql/data/schema-name and try that way, rather then an sql restore. However, I've noticed that this method gives 12 missing tables (there's a .frm file there but no corresponding .myd or .myi). These files/tables are;
  • albumupdated
  • discussion
  • discussionread
  • groupread
  • noticedismiseed
  • pmthrottle
  • prefixpermission
  • profileblockprivacy
  • socialgroupcategory
  • socialgroupicon
  • subscribeddiscussion
  • subscribegroup

Those missing tables gave me a DB error when I tried to view my forum home. I tried installed vb fresh, which works fine, and then did a sql backup of those 12 missing tables - importing them into my existing forum database. That allows me to access my forums and (seemingly) do all normal things, except those related to the missing tables.

------------

I have daily backups made via this mod, but MySQL Admin doesn't like it as it didn't originally make the back up. I don't know if they'd be any use anyway, given the above sql error.

Is there any way I can;
  • try a different sql restore program that allows for ~100MB sql files?
  • get to the stage where I lose all data for the above missing tables, but they don't produce a DB error?
  • break an sql file down, so I can skip out the customavatar table and hopefully get the rest to work? At the moment if I check "ignore errors" no tables alphabetically after customavatar are restored
  • try anything else that might work

I've been trying for days without really getting anywhere so any help would be greatly appreciated. Also, I don't really know anything about mysql, I've just been googling lots and trying different things mentioned, so if you could keep any possible advice noob-friendly that'd also help.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:19 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.06463 seconds
  • Memory Usage 2,202KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)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)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete