Skip to content

Fix phpMyAdmin Import SQL – Unbekannte Sortierung: ‚utf8mb4_unicode_520_ci‘

black flat screen computer monitor

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“

Dieser Beitrag hat 0 Kommentare

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert

An den Anfang scrollen