max. Filesize for .sql-File

[expired user #7238]'s profile image [expired user #7238] posted 11 years ago in General Permalink
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
ansgar's profile image ansgar posted 11 years ago Permalink
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.
[expired user #7238]'s profile image [expired user #7238] posted 11 years ago Permalink
thanks for informations. I will try it.

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