I'm trying to upload some files larger than 5Meg to Tiki Wiki CMS. Tiki uses MySQL. So I added "max_allowed_packet=128M" to "my.cnf" (reference http://tinyurl.com/c9ol9za ) but MySQL still reports that "max_allowed_packet=5M". So where do I change max_allowed_packet so it takes in MySQL?
Update: It turns out that something else was the bottleneck to uploading files larger than 5Meg to Tiki Wiki CMS. After updating to Tiki 10.2, I uploaded a 6Meg file. Don't know if it was an application issue (likely) or inmotion reconfigured something with their MySQL server (unlikely).
You will most likely have to actually the local php.ini file. You will not be able to change the CNF file specific to the server since you're on a Shared server. The change you're looking for will need to made in PHP.INI, though. Check out this article - you will see the section for max upload:
If you have any further questions, please contact technical support or leave a comment at the bottom of the page.
Unfortunately, updating the php.ini file does nothing. Taking the further step of making php.ini recursive broke my other website (500 server error).
I read the MySQL documentation and this variable is supposed to be set in a MySQL configuration file. So I tried it on a non-hosted test server and it worked ("max_allowed_packet=128M" in /etc/my.cnf).
So how do change "max_allowed_packet" on this MySQL server?