I am using MySQL Workbench CE to migrate one schema from a server to another, all table is migrated successfully, except one table with blob data.
The error message is :
Found record bigger than max_allowed_packet.
I have set the
max_allowed_packet to 1M on target server, and restarted MySQL, but still got the same error.
And I checked data in that table:
select max(OCTET_LENGTH(file_Data)) from attachment; ------ 680960 select sum(OCTET_LENGTH(file_Data)) from attachment; ------ 5165578
How can this be fixed?