Überspringen zu Hauptinhalt

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