Error:: MySQL server has gone away??

[gyash]

Hi All
I have a script which uploads files to database. For this i have
a column in database with type longblob and in my php.ini i have set the upload_max_filesize to 2MB whenever i try to upload file > 1MB and less than 2MB it gives error : " MySQL server has gone away". What can be the problem.

Thanks
gyash

[tsinka]

Which OS/distribution ?

[gyash]

I have mysql 4.0.4-beta-max-nt and Windows 2000.

[tsinka]

Hi,

check the my.cnf (or my.ini) configuration file of MySQL if the parameter max_allowed_packet exists and if it has at least a value of 2MB. Otherwise MySQL would refuse to insert the data and "go away". You can use one of the my-small, my-medium ... files in the MySQL install directory for reference.

[gyash]

Hi
Thanks for Reply. But i couldn't find parameter max_allowed_packet in my.ini file. can i add this
parameter manually.

[tsinka]

Of course you can 🙂

Just check one of the example my-???? files in the MySQL root installation folder to check where it should be.

Example:

[mysqld]
....
set-variable = key_buffer=384M
set-variable = max_allowed_packet=2M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8

Try number of CPU's*2 for thread_concurrency

set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
.....

The other parameters might be also useful but you must adjust them to values according to the amount of RAM in your server.

But don't forget the [mysqld] tag. The my.ini file has to be in the windows or winnt folder.

[gyash]

Thanks a million.. 🙂 Now my script is working.