max_allowed_package problem

From: Wojciech Karlowski (wkarlowski_at_web.de)
Date: 01/26/05 

To: dbi-users@perl.org
Date: Wed, 26 Jan 2005 15:19:21 +0100

Hi,

I am using Linux Debian (Sid) with libdbi-perl version 1.46-5 and mySQL
version 4.1. Currently, I am trying to set up a perl script which will
use the DBI module to connect to database. Everything works fine unless
I try to insert large (around 18MB) text object. When I do this I get a
following error:

!! ERROR: 2020 'Got packet bigger than 'max_allowed_packet'

I have already changed to settings for the "max_allowed_package"
variable in the mysql server config (/etc/mysql/my.cnf) and in the local
settings (~/.my.cnf) file.

When I issue the same statement using the mysql client everything works
w/o problems.

Does someone know where can I set up the "max_allowed_package" variable
for the DBI-driven connection? Obviously, it doesn't care about the
server or client settings!

TIA, Wojtek

Relevant Pages

  • Re: using php to move rows from text file into mysql table
    ... In Excel it is dd/mm/yyy ... your own date string in MySQL format. ... MySQL will accept 2 or 4 digit years, ... you cannot type in a query that works at the MySQL client prompt. ...
    (comp.lang.php)
  • Re: [SLE] mysql permissions in 9.2
    ... >>There seems to be some fundamental change in the permissions in mysql as ... > to a new MySQL while using an old MySQL client, ... Please note that the BBC monitors e-mails sent or received. ...
    (SuSE)
  • Re: visualworks and mysql
    ... > My OS pc is windows xp professional: I have installed visualworks 7.3.1 ... > upgrading MySQL client. ... Maybe you could, like, upgrade the MySQL client? ...
    (comp.lang.smalltalk)
  • Re: MySQL5 & PHP5
    ... >> You're apparently using the MySQL client library bundled with the Windows zip ... >> distribution, rather than one from your MySQL installation. ... changing your MySQL client will have little or no effect on the PHP mysql ...
    (comp.lang.php)
  • RE: [SLE] mysql client server, sock miss-match
    ... Have you tried changing the socket path in my.cnf to /var/lib/mysql/mysql.sock? ... mysql client server, ...
    (SuSE)