error when i dump sql data!!

hello everybody,
i have some problem with my server which is :

i have a sql file 1.3GB yes GB error when i dump sql data!!
when i try to dump it into my database by SSH i getting a error massege says : "ERROR 1153 at line 1941: Got a packet bigger than 'max_allowed_packet'"

i did this to change "'max_allowed_packet'" :
pico /etc/my.cnf
max_allowed_packet = 2000M
and save file and
mysqld restart

but no thing change when i try to dump the massege will come back error when i dump sql data!!

i have a big table in my sql file the size of it is 1.2 GB
the dump stop in 4000 records and quit dumping.

please let me know if you have any help for that issue.

thanks

 

 

 

 

Top