Crash on importing large SQL file

[expired user #8656]'s profile image [expired user #8656] posted 9 years ago in Import/Export Permalink
I am currently trying to import an old .sql file (1.2 GB) and it doesn't load. I get the following error:
/* End of file block was cut within some multibyte character, at position 1.153.802.950. Increasing chunk size and retry reading... */

I checked the position it reported, there seems to be nothing weird. If I remove the last character (0x0A), it reports that the second last character is the problem.
ansgar's profile image ansgar posted 9 years ago Permalink
Yes, I had seen that error before. That must be some stream reading error on utf8 files. Try importing that file per mysqldump.exe .
[expired user #8656]'s profile image [expired user #8656] posted 9 years ago Permalink
I don't have any SSH or physical access to the machine, just MySQL.
ansgar's profile image ansgar posted 9 years ago Permalink
If you can connect via HeidiSQL you should also be able to connect via mysqldump, shouldn't you?

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