When I try to export a 414MB table from a 5.5.44-MariaDB (Webserver) to my local MariaDB (5.5.44) HeidiSQL crashes.
This is the structure of the table:
CREATE TABLE Userdateien
(
ID
INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
UserID
INT(4) NOT NULL,
Timestamp
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
Dateiname
VARCHAR(260) NOT NULL,
Dateityp
VARCHAR(100) NOT NULL,
Dateiinhalt
LONGTEXT NOT NULL,
Dateigroesse
VARCHAR(30) NOT NULL,
GelesenAm
TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (ID
)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;
Any suggestions? Thank you!