Crashed at load backup

[expired user #9953]'s profile image [expired user #9953] posted 8 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 8 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.

[expired user #9953]'s profile image [expired user #9953] posted 8 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.