Error during database migration: Need to increase the max_allowed_packet limit

Question

Context:

Currently, our team has decided to use Azure Database for MySQL to migrate the database service from a VPS server and subsequently automate all processes in Azure applications. However, we believe that our project doesn't require more than the $15 plan as it's not very large and doesn't need many resources.

Problem:

When attempting to execute the SQL containing our database backup, we encounter an error in a table with a field type of 'TEXT' where we store a JSON with an array of items. This field is primarily required as it resolves issues related to changes and records for payment attempts. We don't store too much data except for the items, so it doesn't become too large. However, we believe the plan is limiting this capacity in the MySQL server's record, and we can't find a way to enlarge this package without having to pay nearly 10 times more than what the basic plan costs.

I appreciate your time in advance. Thank you very much.

Answer 1

Hi Miguel Aguayo,

Welcome to Microsoft Q&A forum.

As I understand, you are getting Error during database migration: Need to increase the max_allowed_packet limit.

Please refer to the solutions discussed over this Stackoverflow thread for same error which might help in your case:

https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size#:~:text=You%20need%20to%20create%20a,you%20may%20need%20a%20reboot)..)

at this MySQL page:

https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html

Also check filenames if correct as suggested in solution here: https://dba.stackexchange.com/questions/45665/what-max-allowed-packet-is-big-enough-and-why-do-i-need-to-change-it

Let us know the outcome else we will continue to engage more on the issue.

Thanks