phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

by

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

If it’s related to wordpress, more info on why it is happening.

More Related Contents:

  1. Can I store query result of one field into different variables? if not then what should I do for that?
  2. The requested URL was not found on this server.
  3. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  4. What is the best collation to use for MySQL with PHP? [closed]
  5. How to write a stored procedure using phpmyadmin and how to use it through php?
  6. Import file size limit in PHPMyAdmin
  7. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  8. Mysql event error using php
  9. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  10. Store procedures in phpMyAdmin
  11. How to solve time out in phpmyadmin?
  12. WAMP/MySQL errors not in correct language
  13. phpmyadmin automatic logout time
  14. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  15. Unknown database error in PHP but it exists in PHPMyAdmin
  16. Extension mysqli is missing, phpmyadmin doesn’t work
  17. How to SELECT DEFAULT value of a field
  18. How to log in to phpMyAdmin with WAMP, what is the username and password?
  19. Auto Increment skipping numbers?
  20. How to write a stored procedure in phpMyAdmin?
  21. Installing PDO driver on MySQL Linux server
  22. Just using mysql real escape string [closed]
  23. Many-to-many relationships examples
  24. MySQL Join two tables with comma separated values
  25. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  26. How to delete mysql row after time passes?
  27. Echo menu tree with recursive function
  28. Connect DATABASE Error TYPE: 2002: Permission denied
  29. How to convert excel file into mysql database? [duplicate]
  30. How to upload image PHP and insert path in MySQL?

Leave a Comment