Last Updated: March 15, 2016
·
581
· anriettec

Import .sql from Sqlyog to Sequel Pro error

I have long struggled with this, as you would think sqlYog exports SQL dumps as UTF-8.

However, when trying to import an SQL dump file exported by slqYog into a database using Sequel Pro, I usually get an error somewhere along the process indicating an error with encodings.

I have tried a few different encodings, and it seems using Western (ISO Latin 1) does the trick in getting past the error and successfully imports the SQL dump.

//Edit:
So this guy states Western (Mac OS Roman) will also work.