MySQL - Import and Unknown collation: 'utf8mb4_unicode_ci

Unknown collation: 'utf8mb4_unicode_ci' and the import fails.

Solution

1) Click the "Export" tab for the database
2) Click the "Custom" radio button
3) Go the section titled "Format-specific options" and change the dropdown for "Database system or older MySQL server to maximize output compatibility with:" from NONE to MYSQL40.
4) Scroll to the bottom and click "GO".