InMotion Hosting Support Center

Where can I change "max_allowed_packet" for MySQL?

Category: Databases

2013-03-21 5:28 pm EST

Hits: 8,832
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 ) but MySQL still reports that "max_allowed_packet=5M". So where do I change max_allowed_packet so it takes in MySQL?

You must login before you can ask a follow up question.

You must login before you can submit an answer.

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).
8 Points
2013-04-05 03:18 pm EST



40,371 Points
2013-03-21 6:15 pm EST
Hello AlexCampean,

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:

Update Local PHP Settings

If you have any further questions, please contact technical support or leave a comment at the bottom of the page.


Arnel C.

You must login before you can post a comment about this answer.

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?
8 Points
2013-03-22 8:28 am EST
Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

Social Login Joomla

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!