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. After Import: Insert “Use” Statement in Database
  16. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  17. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  18. How to use mysqli_query() in PHP?
  19. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  20. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  21. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  22. Column count doesn’t match value count at row 1
  23. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  24. MySQL string replace
  25. Cannot add or update a child row: a foreign key constraint fails
  26. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  27. String concatenation in MySQL
  28. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  29. Cannot add or update a child row: a foreign key constraint fails
  30. MySQL Error “Operand should contain 1 column”
  31. How to use MySQL DECIMAL?
  32. Access denied for user ‘root@localhost’ (using password:NO)
  33. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  34. How to make MySQL table primary key auto increment with some prefix
  35. Access denied for user ‘root@localhost’ (using password:NO)
  36. MySQL ERROR 1290 (HY000) –secure-file-priv option
  37. MySQL error 2006: mysql server has gone away
  38. Which MySQL data type to use for storing boolean values
  39. sql query with multiple where statements
  40. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  41. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  42. Cannot delete or update a parent row: a foreign key constraint fails
  43. Cannot delete or update a parent row: a foreign key constraint fails
  44. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  45. MySQL server startup error ‘The server quit without updating PID file’
  46. Rename a column in MySQL
  47. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  48. Cannot delete or update a parent row: a foreign key constraint fails
  49. Export Pervasive to MySQL (C#)
  50. MySQL server startup error ‘The server quit without updating PID file’
  51. How do I restore a dump file from mysqldump?
  52. Syntax error due to using a reserved word as a table or column name in MySQL
  53. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  54. MySQL root password change
  55. Installation of MySQL for Visual Studio 1.2.8 failed
  56. Not unique table/alias
  57. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  58. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  59. Your password does not satisfy the current policy requirements
  60. How do I quickly rename a MySQL database (change schema name)?
  61. What does SQL Select symbol || mean?
  62. How do I import an SQL file using the command line in MySQL?
  63. Install mysql-python (Windows)
  64. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  65. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  66. SQL – Update multiple records in one query
  67. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  68. What is the definition of cardinality in SQL
  69. How to restart remote MySQL server running on Ubuntu linux?
  70. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  71. MySQL DROP all tables, ignoring foreign keys
  72. #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
  73. When to use SELECT … FOR UPDATE?
  74. Import / Export database with SQL Server Server Management Studio
  75. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  76. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  77. Setting up foreign keys in phpMyAdmin?
  78. Select from multiple tables without a join?
  79. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  80. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  81. SQL Query Where Field DOES NOT Contain $x
  82. Create a new database with MySQL Workbench
  83. Duplicating a MySQL table, indices, and data
  84. Disable ONLY_FULL_GROUP_BY
  85. what does “/index.php?admin/admin_dashboard” in my url mean
  86. Column ‘user_id’ in field list is ambiguous
  87. How to join two tables by multiple columns in SQL?
  88. How to get size of mysql database?
  89. mysql Foreign key constraint is incorrectly formed error
  90. Database sharding vs partitioning
  91. Selecting data from two different tables without using joins
  92. MySQL WHERE IN ()
  93. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  94. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  95. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  96. SQL – Update multiple records in one query
  97. Difference between VARCHAR and TEXT in MySQL
  98. mysql is not recognised as an internal or external command,operable program or batch
  99. 1052: Column ‘id’ in field list is ambiguous
  100. Escape string Python for MySQL
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)