[Error:] MySQL server has gone away

[Anon]

Hi, I got this above shown error message when I am trying to upload any file larger than 1 MB (any file less than that is fine). I have checked the php.ini which stated 10MB and in my upload HTML form I have this tag <input type='hidden' name='MAX_FILE_SIZE' value='10485760'>

Anybody knows why I am getting the error message ?

[Anon]

hi,
maybe there's a field value in the file (you want to upload) has the same character (ie. ' or ") as the delimiter character that you used. so mysql will interpret it as the delimiter and it will terminate the upload process or add it as a new field which will not match with your table definition.

[Anon]

Manuals are your friends:

19.2.1 MySQL server has gone away error

<snip snip>

You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that
something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can
increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M). The extra memory is allocated on demand, so mysqld will
use more memory only when you issue a big query or when mysqld must return a big result row!

[Anon]

Thanks People,

I found the solution in www.mysql.com, yes, it has got to do with the max_allowed_packet

Thanks🙂