When doing an INSERT with a lot of data, ie:
INSERT INTO table (mediumtext_field) VALUES ('...lots of text here: about 2MB worth...')
"OperationalError: (2006, 'MySQL server has gone away')"
This is happening within a minute of starting the script, so it is not a timeout issue. Also,
mediumtext_field should be able to hold ~16MB of data, so that shouldn't be a problem.
Any ideas what is causing the error or how to work around it?
Some relevant libraries being used:
MySQL 5.0.51 (on Windows XP SP3, via xampp, details below)
ApacheFriends XAMPP (basic package) version 1.6.5
- Apache 2.2.6
- MySQL 5.0.51
- phpMyAdmin 2.11.3