Unix Technical Forum

changing 'max_allowed_packet'

This is a discussion on changing 'max_allowed_packet' within the MySQL General forum forums, part of the MySQL category; --> Hello, I have a simple question: how can I change the value of max_allowed_packet ? (I use server version: ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-18-2008, 10:02 PM
Sigfrid
 
Posts: n/a
Default changing 'max_allowed_packet'


Hello, I have a simple question: how can I change the value of
max_allowed_packet ? (I use server version: 5.0.51a MySQL Community Server
on MacOS 10.5)


In my application I upload file but sometime I get this error

Mysql::Error: #08S01Got a packet bigger than 'max_allowed_packet' bytes:


Thanjs and have a good 1!

-----
Alla prossima ...
--
View this message in context: http://www.nabble.com/changing-%27ma...p17284967.html
Sent from the MySQL - General mailing list archive at Nabble.com.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-18-2008, 10:02 PM
Juan Eduardo Moreno
 
Posts: n/a
Default Re: changing 'max_allowed_packet'

Hi,

In your my.cnf put this :

[mysqldump]
quick
max_allowed_packet = 32M

Regards,
Juan

On Fri, May 16, 2008 at 6:55 PM, Sigfrid <sigbackup@gmail.com> wrote:

>
> Hello, I have a simple question: how can I change the value of
> max_allowed_packet ? (I use server version: 5.0.51a MySQL Community Server
> on MacOS 10.5)
>
>
> In my application I upload file but sometime I get this error
>
> Mysql::Error: #08S01Got a packet bigger than 'max_allowed_packet' bytes:
>
>
> Thanjs and have a good 1!
>
> -----
> Alla prossima ...
> --
> View this message in context:
> http://www.nabble.com/changing-%27ma...p17284967.html
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=j...domc@gmail.com
>
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 05-18-2008, 10:02 PM
Norbert Tretkowski
 
Posts: n/a
Default Re: changing 'max_allowed_packet'

Am Freitag, den 16.05.2008, 14:55 -0700 schrieb Sigfrid:
> Hello, I have a simple question: how can I change the value of
> max_allowed_packet?


http://dev.mysql.com/doc/refman/5.1/...variables.html

Norbert

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:42 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com