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

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.

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

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??

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.

thankyou sir will get in contact with them