When importing database, it shows error

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

UPDATE:
You should also replace in your sql exported file TYPE=MyISAM with ENGINE=MyISAM

Related Posts:

  1. I broke database after reuploading local version – what exactly happened? Database error
  2. Why is my database import losing text widget data?
  3. Get error messages when $wpdb->insert() returns false?
  4. Detecting errors generated by $wpdb->get_results()
  5. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  6. $wpdb->prepare() warning in WordPress 3.5
  7. Changing the Database Connection Error Message
  8. What’s the database relationship between a post and its attachments
  9. Export WP database for import using WP-CLI on Vagrant Box
  10. Importing posts from old website to new conflicting post ID’s?
  11. Strange Deadlock database error for the query “Delete From wp_options”
  12. WordPress showing install screen after max_questions error
  13. What causes the “max_user_connections” warning on WordPress frontend?
  14. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  15. Error establishing a database connection – with Debug Data
  16. Is a direct or import approach safer for migration into WordPress?
  17. MySQL Syntax Error upon restoring database from backup [closed]
  18. error establishing a database connection
  19. Error: SELECT SQL_CALC_FOUND_ROWS
  20. Error establishing a database connection on Installation
  21. SQL Error wp_commentmeta – incorrect table definition
  22. Import live site to local setup without access to live site
  23. Moving WP from local server to live, error establishing a db connection
  24. Error establishing a database connection; After importing DB & Theme
  25. Where are WP_Errors Saved
  26. WordPress database import: Row size too large
  27. $wpdb doesn’t like to store arrays
  28. Error establishing database connection – high traffic?
  29. Export / import WordPress database
  30. Catalina an MAMP Database Conenction Error
  31. Merging two databases without borking it
  32. Importing CSV into database table not working?
  33. Import users from old WP site to new one
  34. Trouble Migrating all data blog from WordPress.com to WordPress.org
  35. How to fix database error duplicate entry
  36. Connection refused on locahost after importing database?
  37. Moving to another server database connection error [closed]
  38. “Error establishing a database connection” – Intermittent error on GoDaddy
  39. Importing Direct to DB – GUID Question
  40. Problem in using wpdb
  41. How can I restrict php mail() to only send me one email after a db error
  42. Best practice to import user base (subscribers) from one website to another?
  43. Importer fails to import every post
  44. Global__r connection timed out
  45. WordPress database products structure
  46. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  47. Is it good practice to import/export a blog to test a redesign?
  48. Error establishing a database connection in wordpress site , website not opening
  49. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
  50. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  51. SQL database import #1046 error
  52. Featured image from custom to WordPress database
  53. error establishing a database connection 3
  54. “wordpress error in establishing database connection” and missing tables
  55. error establishing database connection (WAMP + filezilla)
  56. Hang Up Followed By Can’t select database
  57. Database error after importing WordPress
  58. Catchable fatal error in formatting.php
  59. What am I doing wrong here? WordPress database error
  60. Restoring .sql backup results in “Error establishing a database connection”
  61. Print output of Table Creation
  62. Error at time of WordPress Installation
  63. WordPress database error Unknown column
  64. Importing Concrete5 content to WordPress
  65. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  66. Database Errors since site updated to WordPress 6.4.3
  67. update_post_meta returns ID, but nothing in the database
  68. wp-admin login redirecting to home page
  69. Staging sites, how do you manage synchronising updates in the DB?
  70. How to get the post publish date outside the loop?
  71. Using transients in conjunction with memcached
  72. Forcing nickname as display_name in custom edit profile template
  73. Corrupt WordPress Database
  74. Updating all rows of table with $wpdb
  75. What actions affect files, DB, or both?
  76. What is stored in the webserver? (Separated Database)
  77. Remove database entries where post_date > expiration date
  78. Single database for multiple instances
  79. Search and replace special characters (å,ä,ö) for image attachments only in database
  80. Accidentally deleted active_plugins portion of the wp_options DB table
  81. delete post meta from db, even if does not exist?
  82. In what part of the WordPress core does the users table and usermeta table get joined?
  83. Reducing Database Query Time
  84. How can I get my wordpress password from an SQL file?
  85. Is there an atomic way to update_option in WordPress (to ensure data integrity)?
  86. Selectively restoring original posts from a compromised site to a freshly installed WordPress database
  87. $wpdb is not initiating
  88. Duplicated site isn’t recognized as a site
  89. wordpress database restore – broken link
  90. 6 random character prefix automatically added to entire DB tables, how / why? [closed]
  91. What unexpected data might be stored in terms table and related tables?
  92. Db connection problem on Azure Since database moved on CLEARDB
  93. How to get specific table by current user login
  94. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  95. do I need to change the default database prefix?
  96. How to write to wp-users table
  97. Theme options not being sent to Database
  98. What is good W3 total database caching option? [closed]
  99. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  100. How to STOP wordpress trying to update database?

Leave a Comment