MySQL Error: Packets larger than Max_allowed_packet is not allowed solutions

In the case of large capacity data, especially CLOB data, an exception may occur: "Packets larger than Max_allowed_packet is not allowed".

This is because the MySQL database has a system parameter Max_allowed_packet, and its default value is 1048576 (1M)

You can query its values in the database by using the following statement:

Show VARIABLES like '%max_allowed_packet% ';

To modify this parameter, locate the My.ini file in the MySQL folder and add a line in the My.ini file [mysqld]:

max_allowed_packet=16777216

Restart MySQL so you can import less than 16M of data, of course, this value can be adjusted as needed.

Reference: Quickly import Oracle data to MySQL using MySQL migration toolkit

MySQL Error: Packets larger than Max_allowed_packet is not allowed solutions