Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Crashed at load backup

Conwell's profile image Conwell posted 6 years ago in Running SQL scripts Permalink

When loading not big file ~7Mb crashed at loading file with log notice " End of file block was cut within some multibyte character, at position 7 162 239. Increasing chunk size and retry reading..."

Restore backup in console (cmd.exe) passes without any problems. (mysql.exe -umysqluser -p databasename < backup.sql)

bugreport attached.

1 attachment(s):
ansgar's profile image ansgar posted 6 years ago Permalink

That's mostly caused by using the "Auto-detect" option for the character encoding of the selected file. Please try to select the right encoding (utf-8 mostly) when loading the file per file-open-dialog.

Conwell's profile image Conwell posted 6 years ago Permalink

I think problem with file encoding. Trying utf8 and auto encoding when loading file, but crushed with notice " End of file block was cut within some multibyte character, at position ...". Also this file is locked for rename while heidi is open. I attach schema that not loading to query tab.

File created with phpMyAdmin 3.5.1 and utf8 encoding.

1 attachment(s):

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.