RE: error when trying to load large dump files

ROTECTED]] Sent: Tuesday, May 28, 2002 1:50 PM To: mySQL List Subject: error when trying to load large dump files I've created a dump file using mysqldump that is about 4MB. When I try to load it on another server using "mysql database < dump.sql" I get errors. If I create a

error when trying to load large dump files

I've created a dump file using mysqldump that is about 4MB. When I try to load it on another server using "mysql database < dump.sql" I get errors. If I create a smaller dump file (below 1MB) it loads without a problem. I noticed that the default max_allowed_packet size is 1MB, but I've not had