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,

 

[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.

 

[Tango]

Open a mysql prompt

mysql -uroot -p

And type.
set global max_allowed_packet=1000000000;
set global net_buffer_length=1000000;

Import the database, then restart mysql.

 

[WebCare360]

you need to edit .cnf file