How To Fix This On Dedicated Server

[Mulana]

Hello friends,

Friends, I just got my dedi server a few days back and still playing with it. But I am facing problem that, when I tried to restore a big database around 800+MB via shell access, it shows me this error :

ERROR 1153 (08S01) at line 1850: Got a packet bigger than 'max_allowed_packet' bytes

I tried to search for the solution in Google but just got the idea that I need to edit php.ini. I tried this via my WHM but not worked for me.

Please, tell me infact guide me how to edit php.ini to solve this problem

Further, is there any way I could learn basic server management ?

Thanks,

Mulana Reviewed by Mulana on 14th Dec 2011. How To Fix This On Dedicated Server Hello friends, Friends, I just got my dedi server a few days back and still playing with it. But I am facing problem that, when I tried to restore a big database around 800+MB via shell access, it shows me this error : ERROR 1153 (08S01) at line 1850: Got a packet bigger than 'max_allowed_packet' bytes I tried to search for the solution in Google but just got the idea that I need to edit php.ini. I tried this via my WHM but not worked for me. Please, tell me infact guide me how to Rating: 5

[ibby]

shell> mysql --max_allowed_packet=1000M
u can change 1000m

[luan]

You have to edit this file: /etc/my.cnf

Put your max_allowed_packet to 16M or whatever you want.

max_allowed_packet=16M

[Mulana]

It still shows the same error :-s

how to edit this in shell bro :-s

[ibby]

ssh mysql --max_allowed_packet=1000M

[Mulana]

None of this is working for me. Because in /etc/my.conf there is only :

set-variable = max_connections=500
log-slow-queries
safe-show-database

And while using ssh mysql --max_allowed_packet=1000M the same error comes.

[Gavo]

This site is using a hacked database of W junction

[WebCare360]

you need to edit .cnf file