PDA

View Full Version : A few database errors...need help

Gwhooooey
Fri 27th Jun '03, 11:17pm
When I try to 'Save data to file on server' I get the following errors...can someone help me fix them. I'm with netfirms if that helps

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: SELECT * FROM attachment
mysql error: MySQL client run out of memory

mysql error number: 2008

Date: Friday 27th of June 2003 10:15:07 PM
Script: www.site.com/admin/backup.php
Referer: http://www.site.com/admin/backup.php?action=choose&s=

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE session SET lastactivity=1056766501,location='' WHERE sessionhash='53a4f4400e5686bec00cf3f5c41ec1d3'
mysql error: Lost connection to MySQL server during query

mysql error number: 2013

Date: Friday 27th of June 2003 10:15:08 PM
Script: http://www.site.com/admin/backup.php
Referer: http://www.site.com/admin/backup.php?action=choose&s=
eva2000
Fri 27th Jun '03, 11:42pm
take a read of http://www.mysql.com/doc/en/Out_of_memory.html

how large is your forum database total, how large is the attachment table ?

if it's larger than 50-100MB , you should NOT use vB admin backup script as it will time out, or do what happened here in your case

use ssh telnet and mysqldump (guide here http://www.sitepoint.com/article/678) and try again

you may also need mysql fine tuned so please provide the following info ask here http://www.vbulletin.com/forum/showthread.php?t=70117
Gwhooooey
Sat 28th Jun '03, 7:43pm
Attachment - 27.6 MB
Total - 45.5 MB

Anymore help you can give me?
eva2000
Sat 28th Jun '03, 7:57pm
i guess even small databases depending on hardware need to use mysqldump

solution: You need to use ssh telnet and mysqldump (guide here http://www.sitepoint.com/article/678) and try again

you may also need mysql fine tuned so please provide the following info ask here http://www.vbulletin.com/forum/showthread.php?t=70117
Gwhooooey
Sat 28th Jun '03, 7:59pm
How do I find this information, as I said I'm using netfirms as my host and using the phpMyAdmin thingy there
eva2000
Wed 2nd Jul '03, 12:45pm
How do I find this information, as I said I'm using netfirms as my host and using the phpMyAdmin thingy there
you'll need to contact your web host for the information