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)).
To solve this, delete all the tables and try again with encoding 'Western: Mac OS Roman'.
Comments
That just worked like a charm
That just worked like a charm. Tnx!
Thank you so much! Worked
Thank you so much! Worked Perfectly!!
Excellent, thanks!
Excellent, thanks!
Legend! Thank you.
Legend! Thank you.
It works!
It works!
Thank you for this!
Thank you for this!
This even works for for files
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
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
Thanks for sharing your solution, it also works for me. :-)
Saved the day, thanks
Saved the day, thanks
Thank you so much for this!
Thank you so much for this!
Thank You Sir, You're
Thank You Sir, You're lifesaver!
thanks you , mate
thanks you , mate
Thanks you :)
Thanks you :)
thanks man
thanks man
If you don't want to delete
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 a lot man!
Thanks, worked
Thanks, worked
yay it works!
yay it works!
Hi! I changed it to the
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
Thank you very much works like a charm!
Great! Thank you!
Great! Thank you!
God bless you
God bless you
Saved the day, thanks
Saved the day, thanks
Not working here. Nothing is
Not working here. Nothing is imported despite a message suggesting it has completed the task.
Thanks
Thanks
thank you!
thank you!
Thank you!
Thank you!
fix still works, thanks!
fix still works, thanks!
wow.. it was so cool...
wow.. it was so cool...
Wow, worked a charm, thanks!
Wow, worked a charm, thanks!
Thanks! You saved my life.
Thanks! You saved my life.
Thanks.
Thanks.
nice
nice
Why does this work?
Why does this work?
Old post but still works !…
Old post but still works !
Thanks for this man
Brilliant - thank you
Brilliant - thank you
I love you
I love you
2021 and still working.
2021 and still working.
This just worked for me too!
This just worked for me too!
Thaaaanks!
Thaaaanks!
Thanks! You saved my life.
Thanks! You saved my life.
Great, it worked! Thank you!
Great, it worked! Thank you!
Can confirm, still works…
Can confirm, still works sweet!
And again thanks save my day
And again thanks save my day
Nice!
Nice!
Ran into it just now... It…
Ran into it just now... It still works..! Damn :)
Add new comment