#1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel

by

The technique in this post worked for me

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”.

I’m not certain if doing this causes any data loss, however in the one time I’ve tried it I did not notice any. Neither did anyone who responded in the forums linked to above.

Edit 8/12/16 – I believe exporting a database in this way causes me to lose data saved in Black Studio TinyMCE Visual Editor widgets, though I haven’t ran multiple tests to confirm.

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. If two columns are 1 then make new column
  3. MySQL: How to reset or change the MySQL root password?
  4. MySQL Server has gone away when importing large sql file
  5. How to display UTF-8 characters in phpMyAdmin?
  6. Restore table structure from frm and ibd files
  7. Why is the estimated rows count very different in phpmyadmin results?
  8. Subqueries with EXISTS vs IN – MySQL
  9. Find and Replace text in the entire table using a MySQL query
  10. How to access remote server with local phpMyAdmin client?
  11. MySQL Order before Group by
  12. Is there a simple way to convert MySQL data into Title Case?
  13. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  14. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  15. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  16. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  17. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  18. How to Import Multiple csv files into a MySQL Database
  19. Composite key as foreign key (sql)
  20. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  21. how to delete duplicate rows from a table in mysql
  22. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  23. SQL: deleting tables with prefix
  24. where does MySQL store database files?
  25. How do I write an SP in phpMyAdmin (MySQL)?
  26. WooCommerce: Finding the products in database
  27. How to get back Lost phpMyAdmin Password, XAMPP
  28. UTF8 problem with MySQL 5
  29. mySQL query to search all tables within a database for a string?
  30. How to search and replace all instances of a string within a database?

Leave a Comment