Last Updated: March 15, 2016
· 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.

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