Database: How to fix the Unknown collation 'utf8mb4_unicode_520_ci error?

When moving databases to other servers, in some cases errors can occur when importing the database. This is often due to outdated software, in this case the MySQL version is on an older version.

Solution: In some cases the SQL file to be imported can be edited with an editor.

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
ersetzen mit:
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

utf8mb4_unicode_520_ci 
ersetzen mit:
utf8mb4_unicode_ci

In some cases it is enough to increase the MySQL version.