Please add Supoort To Big Database

Dear HeidiSQL dev,

I have trouble when try to load sql file for size above 4GB, in 99% proses HeidiSQL Always Not Reponding, please fix.

Thanks,
Best & Regrads.

Are you running this file directly or loading it into Heidi?

Try using the 64bit version of HeidiSQL, not the 32bit version.

Are you running this file directly or loading it into Heidi?

running directly to file

Try using the 64bit version of HeidiSQL, not the 32bit version.

i'm using 32-bit Operating System, there is other solution?

heidi stuck on 99% if i load big sql file size above 4GB, i use Windows 7 Ultimate SP1 32-bit.

Thanks.

I'm a large MySQL db user, and this isn't necessarily a problem with heidi, if you are loading a large sql file into a table with many indicies then mysql itself will bog down which will cause heidi to thrash - even a 4g file will cause heidi to thrash while it waits on mysql to finish, it'll be a few hours. MySQL doesn't do well with importing large tables, especially with large tables with more than a few indexes attached. You can insert directly from the command line instead of using heidi to prove the wait times, then try inserting again with no indexes defined, faster but can still take days/weeks at times.