PDA

View Full Version : 2006 Problem Help


express
Fri 22nd Mar '02, 10:53pm
Trying to restore A db size 65mb, attachment table around 30 megs, get a 2006 server gone away error when trying to restore it gets started on attachment table and stops with this error. here is my mysql file

hope someone can help



[mysqld]
port = 3306
skip-locking
set-variable = max_connections=250
set-variable = max_user_connections=30
set-variable = key_buffer=12M
set-variable = join_buffer=4M
set-variable = record_buffer=4M
set-variable = sort_buffer=6M
set-variable = table_cache=1024
set-variable = myisam_sort_buffer_size=32M
set-variable = thread_cache_size=128
socket = /var/lib/mysql/mysql.sock

Chris Schreiber
Sat 23rd Mar '02, 12:10am
http://www.mysql.com/doc/G/o/Gone_away.html

To fix, add this to your my.cnf file and restart MySQL
set-variable = max_allowed_packet=4M