How to fix Sequel Pro Importing UTF-8 SQL file error

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

This has occurred multiple times for me when locally importing databases from staging WordPress environments running on Linux to MAMP. I use Sequel Pro for local database administration.

Solution

  1. Create a new database with UTF-8 Unicode encoding  utf8mb4_unicode_ci collation.
  2. File  > Import
  3. Select Western (MacOS Roman) in the encoding dropdown
  4. Open the file, it should import without issue.
Was this article helpful?
YesNo