MySQL Workbench Error "Unknown File Encoding"

I had the same problem reported above and found out what happened in my case.

My backups were being hard-coded in utf-8. Until one day he started to give that error reported above.

I discovered that it was because I had just created a table that registered in a field a DOCUMENT, which could be pdf, jpg, png ... anyway.

That was the problem. It was not just registering the file name, but the file itself. This was causing the error.

I deleted the table record and the backup worked perfectly.

Instead of saving the file to the database, I put the database to save only the file name and path. The file has been saved to the server itself.

This depends on which encoding you used to generate your backup, if you did not set the correct encoding to generate your backup you will have accent problems. Note that in the mysql error message it says that your file is not UTF-8 (probably should have been generated as latin), I suggest you check which encoding is being used by your database by doing the following command in your database:

SHOW VARIABLES LIKE "character\_set\_database";

and regenerate your backup by specifying the encoding (this is an example of a backup using utf-8 as an encoding):

mysql --default-character-set=utf8 -u root -p dbname -r dump.sql