MySQL client run out of memory

[cobradude]

Every time I try to back up my database I get the following (pulled this from the file generated) error. So far I have not been able to back up the DB properly, and my web host has told me it's vBulletin, and I called them on it a couple times but they are sticking to their story.

ANY HELP IS APPRECIATED!!!

INSERT INTO pollvote VALUES('67','4','11585','989445968','1');
INSERT INTO pollvote VALUES('68','4','9606','989446500','4');
INSERT INTO pollvote VALUES('69','4','9528','989446917','4');
INSERT INTO pollvote VALUES('70','4','9671','989456363','4');



<br>
<b>Warning</b>: MySQL: Unable to save result set in <b>/home/www/clubcobra/forums/admin/db_mysql.php</b> on line <b>92</b><br>

<!-- Database error in vBulletin Control Panel: Invalid SQL: SELECT * FROM post
mysql error: MySQL client run out of memory
mysql error number: 2008
Date: Wednesday 09th of May 2001 10:20:52 PM
Script: /forums/admin/backup.php
Referer: http://www.clubcobra.com/forums/admi...&action=choose
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>
<!-- Database error in vBulletin Control Panel: Invalid SQL: UPDATE session SET lastactivity=989464828 WHERE sessionhash='0c4970f43716acee1f2b22ecc74d66f9'
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Wednesday 09th of May 2001 10:20:52 PM
Script: /forums/admin/backup.php
Referer: http://www.clubcobra.com/forums/admi...&action=choose
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</

[Wayne Luke]

If you have telnet/ssh access do a backup from the command line.

1. telnet into your system
2. from the root directory, type mysqldump -uUSERNAME -pPASSWORD databasename > /path/to/dump.txt;
3. this should only take no more than 30 seconds
4. when it is completed, it will bring you back to the prompt
5. verify that you have a dump.txt in the /path/to area you specified

If you get the same error, your host needs to update their MySQL configuration.

[cobradude]

Thank you very much for the quick response. I'll give it a whirl tonight!

Cheers!


-Brent

[cobradude]

Is this a vBulletin bug then?

Ok, so doing as you suggested via telnet created the file fine, and it's 125mb big.

Thank you very much!


Since this worked, does it mean there's a bug in vBulletin?

[Wayne Luke]

Not necessarily a bug in vBulletin. It is most likely a combination of constraints put on you by your hosting company to prevent rogue scripts from taking down a server. 125 MB is an awful lot to try and backup through the browser.

There is a script in the following thread that you can set up to backup your database automatically and either FTP or email it to you. This is actually more efficient than the built in backup and better suited for larger installations like yours.

http://www.vbulletin.com/forum/showt...ghlight=backup