Unknown collation when I import a dump from an existing site into a development database?

This issue is as a result of your server not supporting the utf8mb4_unicode_520_ci collation type.

To resolve this you should convert the collation for all tables with utf8mb4_unicode_520_ci to utf8_general_ci

If you’re exporting through phpmyadmin, you can:

  1. Click the “Export” tab for the database

  2. Click the “Custom” radio button

  3. Go the section titled “Format-specific options” and change the
    dropdown for “Database system or older MySQL server to maximize
    output compatibility with:” from NONE to MYSQL40.

  4. Scroll to the bottom and click “GO”.

OR run the following query on each of the affected tables:

ALTER TABLE myTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

Related Posts:

  1. Exporting completed webiste for another server
  2. Export SQL query based on custom field?
  3. How do I import an SQL file using the command line in MySQL?
  4. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  5. How to change collation of database, table, column?
  6. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  7. MySQL Syntax Error upon restoring database from backup [closed]
  8. Error while importing database
  9. Create a form with custom autocomplete address field and CSV import values
  10. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  11. latency problems with wordpress install (from SQL import)
  12. Weird characters displayed when importing WordPress MySQL db
  13. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  14. How do I load a sql.gz file to my database? (importing)
  15. Cannot add or update a child row: a foreign key constraint fails
  16. Cannot delete or update a parent row: a foreign key constraint fails
  17. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  18. Rename a column in MySQL
  19. Not unique table/alias
  20. Install mysql-python (Windows)
  21. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  22. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  23. Disable ONLY_FULL_GROUP_BY
  24. MySQL WHERE IN ()
  25. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  26. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  27. difference between primary key and unique key
  28. How to export a mysql database using Command Prompt?
  29. MySQL Error #1133 – Can’t find any matching row in the user table
  30. How can I prevent SQL injection in PHP?
  31. Best way to store an array in MySQL database?
  32. MySQL date formats – difficulty Inserting a date
  33. How to check if mysql database exists
  34. #1062 – Duplicate entry for key ‘PRIMARY’
  35. How can I convert a string to a float in mysql?
  36. Is there a Profiler equivalent for MySql?
  37. Why is my database import losing text widget data?
  38. How to replace the domain name in a WordPress database?
  39. Optimize WordPress Query that take 5 seconds to execute
  40. MySQL Replication Latency Issues in wp-admin pages
  41. Increment value (value = value+1) of $wpdb->update
  42. How to migrate a WordPress installation from one site to another, including all images?
  43. Import and export links from WordPress.com to private site
  44. How can I debug my database connection for unit testing?
  45. Extending the database
  46. SQL query not working in alphabetical post title/content search
  47. Import Images from one self-hosted WordPress install to another
  48. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  49. Importing MariaDB into Mysql in WordPress
  50. Importing large data from blogger
  51. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  52. Converting mysql to $wpdb
  53. Update a WordPress post or page takes 60+ seconds
  54. add_post_meta does not respect the content
  55. Modify MySQL Query Based on Dropdown Menu
  56. Select multiple wp_postmeta keys with single select
  57. Can’t find my wordpress DB in phpmyadmin
  58. Deprecated: mysql_connect():
  59. Export / import WordPress database
  60. $wpdb select all meta for each post
  61. Calculate average crossing post categories
  62. Replacing link URL ending strings via MySQL
  63. Many slow queries post_type = ‘attachment’;
  64. SQL command to convert all tags in lowercase?
  65. Problem with admin login after deployment
  66. Find out how many times the user has logged in
  67. Is it possible to create a WordPress table using array and loop?
  68. How to stop $wpdb from prepending database name
  69. Importing posts only – consequences?
  70. Importer fails to import every post
  71. Match tag names with form titles
  72. Error missing MySQL extension
  73. Getting Error Trying to Create Table
  74. Best approach for a custom database filling in WP custom post types
  75. Exporting featured image
  76. Why doesn’t custom mysql query return results? Is syntax correct?
  77. Insert two row in wordpress database
  78. product export and import using xml
  79. SQL statement using placeholder is not returning results
  80. How to Bulk find and replace MySQL for post image url
  81. Regular XML-RPC timeouts
  82. update multiple rows in mysqli table base on two values
  83. How can I verify WordPress nonce from the following code?
  84. Moving Featured Images
  85. How to write in MySQL more characters in user_nicename
  86. Merge two wordpress sites
  87. $wpdb->get_var not returning count
  88. Custom user query – orderby meta_key (that may not exist)
  89. How to get Attachments(image) with specific width\height ratio
  90. What is the cron doing?
  91. SQL error on restoring database
  92. MySQL database gives blank page (white screen of death)
  93. Import from HubSpot COS into WordPress 4?
  94. why is $wpdb->update() causing a DB error from within wp_set_password()
  95. Global MySQL replacing of text patterns/matches
  96. Export Posts Without Categories In An XML File
  97. remove wordpress post links
  98. SQL get last entry of a specific gravity form
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?