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

Tags: 

Comments

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

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.