Crash on exporting table from 5.5.44-MariaDB

Program4fun's profile image Program4fun posted 8 years ago in General Permalink

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!

1 attachment(s):

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