Re: Got a packet bigger than 'max_allowed_packet' -> why is mysql so unkind?

2007-08-01 Thread Hartleigh Burton
Hi Gerald, I have set the max_allowed_packet to 1G on both servers. Any other ideas by any chance? Regards, Hartleigh Burton Resident Geek MRA Entertainment Pty Ltd 5 Dividend St | Mansfield | QLD 4122 | Australia Phone: (07) 3457 5041 Fax: (07) 3349 8806 Mobile: 0421 646 978 www.mraente

Got a packet bigger than 'max_allowed_packet' -> why is mysql so unkind?

2007-07-31 Thread Hartleigh Burton
file into the empty database on the new server I receive the message "ERROR 1153 (08S01) at line 92: Got a packet bigger than 'max_allowed_packet' bytes". I see so many people on forums everywhere that get the same issue... but can not seem to find an ans

Re: Got a packet bigger than 'max_allowed_packet' bytes

2006-05-18 Thread Kishore Jalleda
gt; about 7000 lines, on an 800M dump. I guess this tells me I have some > extremely long lines, which would be happy to take up more than > 'max_allowed_packet' bytes, which is set to 16M. > > The specific error I get is: > > ERROR 1153 (08S01) at line 3132: Got a pac

Re: Got a packet bigger than 'max_allowed_packet' bytes

2006-05-18 Thread Dan Trainor
s me I have some extremely long lines, which would be happy to take up more than 'max_allowed_packet' bytes, which is set to 16M. The specific error I get is: ERROR 1153 (08S01) at line 3132: Got a packet bigger than 'max_allowed_packet' bytes Using: mysql -uroot -p database

Re: Got a packet bigger than 'max_allowed_packet' bytes

2006-05-18 Thread Kishore Jalleda
ong lines, which would be happy to take up more than 'max_allowed_packet' bytes, which is set to 16M. The specific error I get is: ERROR 1153 (08S01) at line 3132: Got a packet bigger than 'max_allowed_packet' bytes Using: mysql -uroot -p database < /tmp/800MSQLFile.sql

Got a packet bigger than 'max_allowed_packet' bytes

2006-05-18 Thread Dan Trainor
more than 'max_allowed_packet' bytes, which is set to 16M. The specific error I get is: ERROR 1153 (08S01) at line 3132: Got a packet bigger than 'max_allowed_packet' bytes Using: mysql -uroot -p database < /tmp/800MSQLFile.sql under MySQL 5.0.21. I don't have much experi

Got a packet bigger than 'max_allowed_packet'

2001-08-23 Thread Martin MOKREJŠ
Hi, I have a problem with one machine running Debian kernels 2.4.7 (2.4.9) on Intel EtherExperssPro100 and mysql-3.23.39. When I try to upload data into database, I get the error in %Subj%. The command used is: bioadmin@caribou$ cat apernix.contig.sql | mysql --host=pednew ApernixK1 ERROR 2006