MySQL Forums

Hi there.
Im working on a perl program that takes the rows off of one of my tables to manipulate the data.

The problem is that if i take a table that is too large i get the:
DBD::mysql::st execute failed: Lost connection to MySQL server during query at program.pl line 41

If I use a smaller table (in this case ~85,000 records, 8.2MB) I can connect to the database and then pull up all of the rows of the table.. it works just fine. But using a larger table (~265,000 records, 28.3MB) I get the error.

I have tried changing the values of max_allowed_packet and wait_timeout in /etc/my.cnf... but it makes no difference with the problem.

Any ideas?