Seeking Assistance: Need Help Increasing max_allowed_packet Value for Database Migration

Hosting Support
1

Hello InfinityFree Community,

I’m currently in the process of migrating my website and have run into a bit of a hurdle that I hope to get some assistance with. While working on the migration, I encountered an issue related to the MySQL max_allowed_packet setting, which is currently set to 8MB.

This limitation has made it difficult to import my database, as I require the max_allowed_packet value to be at least 16MB or higher to successfully complete the migration process. Unfortunately, I do not have the necessary privileges to change this setting myself, and I am looking for guidance on how to proceed.

Here’s a brief overview of my situation:

  • Current Host: Pantheon
  • Migration to: InfinityFree
  • Issue: max_allowed_packet is set to 8MB, causing import failures during the migration process.

I would greatly appreciate any advice or assistance on how to increase the max_allowed_packet value or any alternative solutions you might suggest for completing my migration smoothly.

Thank you for your time and support!

Best regards,

2

Hello

Server configuration cannot be changed on free hosting. Please work around the limits, or upgrade to a premium plan that has higher limits.

Thanks

2 Likes
3

Not possible. However you can split your database into multiple sql files to stay within the limit

2 Likes
4

Close, but not quite.

The problem is indeed with the import needing to be restructured. But not by having smaller files, but by having smaller SQL statements. Most database exports have the ability to limit how many rows are inserted at once. If the insert query is too big, you run into this limit. The solution is to generate a new export with smaller insert batches.

4 Likes
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.