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.