Sequel Pro file read error when uploading database

June 16, 2017

When I upload a database to Sequel Pro, I often get this 'file read error': 

An error occurred when reading the file, as it could not be read in the encoding you selected (Autodetect - Unicode (UTF-8)). 

Sequel Pro file read error

To solve this, delete all the tables and try again with encoding 'Western: Mac OS Roman'. 

Sequel Pro encoding fix



That just worked like a charm. Tnx!

Thank you so much! Worked Perfectly!!

Excellent, thanks!

Legend! Thank you.

It works!

Thank you for this!

This even works for for files that originally came from Windows! Thanks so much, this was a serious life saver

Thanks so much for this! I thought the problem was with my source database, so never would have figured this out.

Thanks for sharing your solution, it also works for me. :-)

Saved the day, thanks

Thank you so much for this!

Thank You Sir, You're lifesaver!

thanks you , mate

Thanks you :)

thanks man

If you don't want to delete your database or change your encodage, you can use command line in order to import the file. Easy, and powerful.

mysql -uMY_USER -pMY_PASSWORD my_table_db < my_file_to_import.sql

(yes, there's no space between -u and the user nor -p and the password)

Thanks a lot man!

Thanks, worked

yay it works!

Hi! I changed it to the correct settings above and still get the issue of an unexpected error. also trying to connect to an existing database results in it as well. please help!

Thank you very much works like a charm!

Great! Thank you!

God bless you

Saved the day, thanks

Not working here. Nothing is imported despite a message suggesting it has completed the task.


thank you!

Thank you!

fix still works, thanks!

wow.. it was so cool...

Wow, worked a charm, thanks!

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.