[Mediawiki-l] Populating DB (follow up)

Paul Hardwick macronin at yekk.pair.com
Sun Apr 25 19:54:19 UTC 2004


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!!  :-)





More information about the MediaWiki-l mailing list