Crash on exporting big table from MySQL5.1 To MariaDB

Program4fun's profile image Program4fun posted 9 years ago in Import/Export Permalink

When I try to export a 1.3GB table from a MySQL5.1-server (5.1.73) to 5.5.44-MariaDB HeidiSQL crashes with "SQL error (1231): Variable 'foreign_key_checks' can't be set to the value of '1'."

This is the structure of the table:

CREATE TABLE Wartungsdateien ( ID INT(3) UNSIGNED NOT NULL AUTO_INCREMENT, WartungsID INT(4) NOT NULL, Dateiname VARCHAR(255) NOT NULL, Dateityp VARCHAR(100) NOT NULL, Dateiinhalt MEDIUMTEXT NOT NULL, Dateigroesse VARCHAR(30) NOT NULL, PRIMARY KEY (ID) ) COMMENT='...' COLLATE='latin1_swedish_ci' ENGINE=InnoDB AUTO_INCREMENT=5586 ;

Any suggestions? Thank you!

Program4fun's profile image Program4fun posted 9 years ago Permalink

OK, I found a solution: I set the server variable "max_allowed_packet" from 1048576 to 104857600. Now, it works.

Please login to leave a reply, or register at first.