Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 11-14-2005, 10:19 AM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default trouble backing up database via adminCP

hi i'm getting this error trying to back-up my database via admin CP

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM sg_attachment;

MySQL Error : MySQL client run out of memory
Error Number : 2008
Date : Monday, November 14th 2005 @ 07:15:45 AM
Script : http://***************/forum/admincp/backup.php

Database error in vBulletin 3.5.0:

Invalid SQL:

UPDATE sg_session
SET lastactivity = 1131970541, inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '190a441624e4005ca1495a6ecefca171';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Monday, November 14th 2005 @ 07:15:45 AM
Script : http://*****************/forum/admincp/backup.php


anyone got any ideas as to what could be causing this
Reply With Quote
  #2  
Old 11-14-2005, 11:55 AM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

MySQL client run out of memory - your account @ your host allows X amount of memory per user.

Read all before you do any -

1)
optimize the DB - then try again.

2)
Setup a backup on the localhost vs. trying to download the backup instant.
(where mysql DB backs up on your webserver HD) - then File manager / FTP - download it.

3)
Use Cpanel / Vdeck - there will be a mySQL and/or backup area to back up your database. It may also time out on download and you may have to save to locolhost then FTP in to download.

4)
You can always put in a request @ your host to backup your database because : paste your error and why you got it. (they may up the memory useage for your account and/or backup the database for you. (then you log in and download it.)

/// Last resort:

If not a big deal you can remove all the "logs" made by Admin / Mods and the "search index" for the posts to have less to backup - if the records of events are not important.

*the search index can be remade when and if you need to restore your database. The Logs of events will be gone if you remove them, but if not a big deal it may get you past your problem.

Edit: last idea if your attachments / avatars are in your database, change that to filesystem. (this will push all that mess out of the database *making it smaller*) optimize the DB - then try again. Make sure your download your files from the server for now the attachments are files on the webserver.
Reply With Quote
  #3  
Old 11-15-2005, 01:41 AM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hi thanks for your reply i went for 3 saved to local host then used FTP,i tried your other steps from last resort still had no luck,thanks for your advise
Reply With Quote
  #4  
Old 11-15-2005, 02:50 AM
Guest190829
Guest
 
Posts: n/a
Default

Your going to have to talk about this issue with your host, as everything seems to be from the server side...I suggest using SSH or telnet to back up your database. It's the safest and fastest way.
Reply With Quote
  #5  
Old 11-15-2005, 03:23 AM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Danny.VBT
Your going to have to talk about this issue with your host, as everything seems to be from the server side...I suggest using SSH or telnet to back up your database. It's the safest and fastest way.
is there a tut on how to do this thankyou??
Reply With Quote
  #6  
Old 11-15-2005, 04:45 AM
Guest190829
Guest
 
Posts: n/a
Default

Yes:

http://www.vbulletin.com/docs/html/m...nce_ssh_backup

You're going to have to talk to your host to see if you have access for this also.
Reply With Quote
  #7  
Old 11-15-2005, 05:02 AM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thankyou sir will get in contact with them
Reply With Quote
Reply

Thread Tools
Display Modes

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:26 AM.


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.02346 seconds
  • Memory Usage 2,209KB
  • Queries Executed 13 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (5)postbit_onlinestatus
  • (7)postbit_wrapper
  • (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_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • 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
  • 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