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

These error message raise when i run the script like the below:

mysql -u root -p my_database < dump.sql

Then raised:

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

Googling and found:

vi /etc/my.cnf

add these line under [mysqld]

[mysqld]
# added to avoid err "Got a packet bigger than 'max_allowed_packet' bytes"
#
net_buffer_length=1000000 
max_allowed_packet=1000000000
#

Restart the mysql db:

service mysqld restart

Finally, i import the database with successfully:

mysql -u root -p my_database < dump.sql