MySQL Forums
Forum List  »  MySQL Workbench

Error inserting blob into database
Posted by: John Martinson
Date: July 01, 2020 06:52PM

SQLWorkbench 8.0
MYSQL 5.7.30 INNODB
WINDOWS Server 2016

I have a droplet(UBUNTU LAMP) on a provider that I am running MYSQL that works fine.

I have exported SQL files of the data from the Ubuntu droplet via PMA, but when I try to insert it into my local database, I get the "Error Code: 2006. MySQL server has gone away".

It is trying to insert blobs that are 2mb insize.
I have set the max_allowed_packet to 1gb. with it set to 1mb, I got a different error when it was too small.

I have search for solutions, everything points to the max_packet, but that is not helping.

Thanks in advance!
J

Options: ReplyQuote


Subject
Views
Written By
Posted
Error inserting blob into database
91
July 01, 2020 06:52PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.