Where can I change "max_allowed_packet" for MySQL?

Category: Databases

AlexCampean
Asked:
2013-03-21 5:28 pm EST

Hits: 2,443
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?

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

OTHER ANSWERS

0

Arn
Staff
17,325 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.

Regards,

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

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

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: support@InMotionHosting.com
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!