distal-attribute
distal-attribute
distal-attribute
distal-attribute

max. Filesize for .sql-File

User, date Message
Written by mpiontek
12 months ago
Category: General
2 posts since Thu, 29 Aug 13
I need possibility to import files larger than 400MB up to 2GB. Can I import it with GUI and if its possible how can i do it? Whats the maximum file size to import with the gui?


my System: Win 7 / 64x / HeidiSql 8.0.0.4493
Written by ansgar
12 months ago
4973 posts since Fri, 07 Apr 06
In theory HeidiSQL just has a limit of 2^64 for the filesize, that is 18 EiB (Exbibyte). Your file system also has limitations, probably smaller than that. When you load a .sql file into HeidiSQL's editor, you are asked to run it directly (which I strongly recommend for large files). If you do so, HeidiSQL reads the file in chunks of 20MB.

I fixed some read errors recently, but there is still a problem with Unicode files which was reported here. HeidiSQL sometimes sets a split marker within some multibyte character, and then later SQL commands are broken or even empty.

You could test with HeidiSQL, and if it does not work, use the mysql.exe command line utility.
Written by mpiontek
12 months ago
2 posts since Thu, 29 Aug 13
thanks for informations. I will try it.
 

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