[vc_row full_width="stretch_row_content_no_spaces" wpex_bg_color="palette-88"][vc_column][vcex_grid_container][vcex_image image_id="976" fill_column="true" el_class="wpex-row-span-2" aspect_ratio="3/4"][vcex_image image_id="973"][vcex_image image_id="981"][vcex_image image_id="982"][vcex_image image_id="978"][/vcex_grid_container][/vc_column][/vc_row]
How to Handle PHPMyAdmin Error #1273 – Unknown Collation: ‚utf8mb4_unicode_520_ci‘
I recently migrated a database from one server to another. I cannot properly tell which server was newer. BUt I guess it is the source server. Unfortunately the exported MySQL-Database had a collation type the other older MySQL Server could not recognize which prevented a proper import.
Fortunately the solution is rather easy. DO some quick search and replace commands on the exported .sql file (open in ATOM Editor if it is too big):
- Search: utf8mb4_unicode_ci
Replace: utf8_general_ci (Replace All) - Search: utf8mb4_unicode_520_ci
Replace: utf8_general_ci (Replace All) - Search: utf8mb4
Replace: utf8 (Replace All)
Troubleshooting
When you manually import a foreign database. Make sure that the table prefix defined in the wp-config.php file matches the imported prefix! Often this is not the case. When restoring using a backup tool this migh be fixed automatically.