Helo agion,
Sorry for the delay but life interfered with my working on this for a bit. Just thought I'd pass along the results of my trying to Populate the database, and getting past the "ERROR 1153 at line 831: Got a packet bigger than 'max_allowed_packet' " error I was receiving. Maybe the info will save someone else the time. Short version - The parm exists on both the client and server. I had to update the server not the client. BTW I am running MySQL 4.0.18 and PHP 4.3.4 under Apache 2.0.40
Paul
======================================= OK try and load update file
nice mysql -p -uusername dbname < 20040403_cur_table.sql -bash-2.05b$ nice mysql -p -username DBname < 20040403_cur_table.sqlEnter password: ERROR 1153 at line 831: Got a packet bigger than 'max_allowed_packet' -bash-2.05b$ ==== ran for 25+ minutes Then died ============================================================================== OK try #2 Friday, April 9, 2004-1:53 AM Added maxAllowedPacket nice mysql -p -uusername --max_allowed_packet=24M DBname < 20040403_cur_table.sql
-bash-2.05b$ nice mysql -p -username --max_allowed_packet=24M DBname < 20040403_cur_table.sql Enter password: ERROR 1153 at line 831: Got a packet bigger than 'max_allowed_packet' -bash-2.05b$ ============= failed at 24Meg lets try 64 Meg
-bash-2.05b$ nice mysql -p -username --max_allowed_packet=64M DBname < 20040403_cur_table.sql Enter password: ERROR 1153 at line 831: Got a packet bigger than 'max_allowed_packet' -bash-2.05b$ ============= failed at 64Meg http://dev.mysql.com/doc/mysql/en/Packet_too_large.html Checked Doc further and found out that the same parm exists on both server and client and I had only been updating the client - now I'll do the server By adding (/etc/my.cnf):
[mysqld] max_allowed_packet=16M =============file is now -bash-2.05b$ more my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock query_cache_type=1 query_cache_size=10m max_allowed_packet=16M
[mysql.server] user=mysql basedir=/var/lib
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid -bash-2.05b$ ==================== After updating Server to max_allowed_packet=16M
-bash-2.05b$ nice mysql -p -username DBname < 20040403_cur_table.sql Enter password: -bash-2.05b$
:) It works!! :-)