MySQL Forums
Forum List  »  MySQL Workbench

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

SQLWorkbench 8.0
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!

Options: ReplyQuote

Written By
Error inserting blob into database
July 01, 2020 06:52PM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.