Got a packet bigger than 'max_allowed_packet' error

Okay...

I got this error, so I thought, fine, I'll change the max_allowed_packet variable.

So, I went to the documentation, and found this
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

But, the command it gives you for changing the packet size variable doesn't work.

This command:
gives me the "command not found" error.

So, I figured I would find the file (/etc/init.d) and go like this:

But that just gives me the "usage ./mysqld {star|stop|status|etc}" error.

But if I do this:
It won't take in the argument for max_allowed_packet, because I can spell the variable wrong and it doesn't give me an error.

This is getting pretty frustrating. Anyone know how I can change the server variable "max_allowed_packet"?

re: Got a packet bigger than 'max_allowed_packet' error

I found an alternative.

1. Edit the file "/etc/my.cnf":
Under "[mysqld]", enter "max_allowed_packet=100000000M"

2. Then use command:
mysql -p'<password>' --max_allowed_packet=10000000M <database_name> < "/home/<user>/Desktop/<upload_file>.sql"

re: Got a packet bigger than 'max_allowed_packet' error

Yea. But after changing it in the my.cnf file and restarting the MySQL server, it shouldn't be necessary to add the parameter to the mysql command.

Glad you found a solution tho.
Thanks for sharing it.