Fix phpMyAdmin Import SQL – Unbekannte Sortierung: ‚utf8mb4_unicode_520_ci‘

Recently I encountered a problem during import via phpMyAdmin. I had a database from an older server and wanted to import it on a newer one. The newer one had different SQL-version. But there is a quick but rather dirty fix for this annoying error I ran into:

Download the old SQL file and open it with a capable text editor like atom. Just find and replace three strings:

• „utf8mb4″with „utf8“,
• „utf8_unicode_ci“ with „utf8_general_ci“
• „utf8_unicode_520_ci“ with „utf8_general_ci“