database has gone away
Hej,Jeg vil indsætte en binære fil i min database, som fylder over 16 megabyte. Fejlen "Database has gone away" eller "Error in file handler" kommer når jeg indsætter dataen.
Jeg har været inde og rette på my.ini:
#This File was made using the WinMySQLAdmin 1.4 Tool
#22-03-2002 02:50:43
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=D:/webserver/mysql
#bind-address=10.0.0.2
datadir=D:/webserver/mysql/data
#language=D:/webserver/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#skip-locking
default-character-set=latin1
set-variable = key_buffer=200M
set-variable = max_allowed_packet=34M
set-variable = tmp_table_size=200M
set-variable = key_buffer=64M
set-variable = table_cache=25M
set-variable = sort_buffer=34M
set-variable = record_buffer=34M
set-variable = delayed_insert_timeout=9999
set-variable =interactive_timeout=9999
set-variable = query_buffer_size=40M
set-variable = max_sort_length=9999999
set-variable = delayed_insert_limit=40M
set-variable = max_heap_table_size=40M
#set-variable = thread_stack=128K
set-variable = flush_time=18000
[WinMySQLadmin]
Server=D:/webserver/mysql/bin/mysqld-nt.exe
Er der forslag til hvordan jeg skal takle problemet.