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!