Error inserting blob into database
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
Subject
Views
Written By
Posted
Error inserting blob into database
1134
July 01, 2020 06:52PM
488
July 01, 2020 10:35PM
741
March 27, 2021 12:03AM
387
March 28, 2021 03:53PM
352
March 28, 2021 05:23PM
354
March 28, 2021 07:24PM
Sorry, you can't reply to this topic. It has been closed.
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.