{"id":4620,"date":"2017-12-08T18:40:37","date_gmt":"2017-12-08T13:10:37","guid":{"rendered":"https:\/\/phpyouth.com\/blog\/?p=4620"},"modified":"2025-10-14T17:40:57","modified_gmt":"2025-10-14T12:10:57","slug":"how-to-fix-1273-unknow-collation-utf8mb4_unicode_520_ci-mysql-query-error","status":"publish","type":"post","link":"https:\/\/phpyouth.com\/blog\/how-to-fix-1273-unknow-collation-utf8mb4_unicode_520_ci-mysql-query-error\/","title":{"rendered":"How to fix #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’ MySQL query error"},"content":{"rendered":"

Hello Friends, today we will learn how to resolve the MySQL error 1273 utf8mb4_unicode_520_ci in WordPress. This MySQL error #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ often occurs when importing a WordPress database.<\/p>\n

This specific MySQL error often occurs when importing a WordPress database from one host to another using PHPMyAdmin. It can also happen even when importing on the same server.<\/p>\n

\"\"<\/a><\/p>\n

So, here are the steps that will help us fix the MySQL error #1273 \u2013 Unknown collation: ‘utf8mb4_unicode_520_ci’.<\/p>\n

STEP 1:<\/strong> Download your Database file in [.sql] format.<\/p>\n

STEP 2:<\/strong> Open the database file in either Macromedia Dreamweaver<\/strong> or Notepad++<\/strong><\/a>, then use the Search & Replace command (Ctrl+F).<\/p>\n

STEP 3:<\/strong> Next, search for “utf8mb4”<\/strong> and replace it with “utf8”<\/strong>. This will change all instances of utf8mb4_unicode_520_ci<\/strong> to utf8_unicode_520_ci<\/strong>.<\/p>\n

STEP 4:<\/strong> Next, search for “utf8_unicode_520_ci<\/strong>” and replace it with “utf8_unicode_ci<\/strong>“.<\/p>\n

STEP 5:<\/strong> Finally, open PhpMyAdmin and set the database collation to utf8_unicode_ci via Operations >> Collation.
\nTry this, it’ll really work.<\/p>\n

\"\"<\/a>\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Hello Friends, today we will learn how to resolve the MySQL error 1273 utf8mb4_unicode_520_ci in WordPress. This MySQL error #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ often occurs when importing a WordPress database. This specific MySQL error often occurs when importing a WordPress database from one host to another using PHPMyAdmin. It can also happen even when […]<\/p>\n","protected":false},"author":1,"featured_media":4626,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[101,100,4],"tags":[116,117,118,115],"class_list":["post-4620","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-mysql","category-wordpress","tag-1273-unknow-collation-utf8mb4_unicode_520_ci","tag-mysql-error","tag-phpmyadmin","tag-utf8mb4_unicode_520_ci"],"acf":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/12\/1273-\u2013-Unknow-collation-\u2018utf8mb4_unicode_520_ci\u2019.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8zepR-1cw","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":5224,"url":"https:\/\/phpyouth.com\/blog\/create-duplicate-database-using-phpmyadmin\/","url_meta":{"origin":4620,"position":0},"title":"How to make Duplicate\/Clone\/Copy Database using PHPMyAdmin","author":"RK Jajoria","date":"June 2, 2020","format":false,"excerpt":"Hello Friends, how are you? I hope all are feeling well, safe, and at home in this pandemic. I also want to say sorry for not publishing an article in the last 75 days. So today we started again with a new topic, can't say new but yes it's who\u2026","rel":"","context":"In "Database"","block_context":{"text":"Database","link":"https:\/\/phpyouth.com\/blog\/category\/web-hosting\/database\/"},"img":{"alt_text":"DuplicateCloneCopy Database using PHPMyAdmin","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Duplicate-Clone-Copy-Database-using-PHPMyAdmin.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Duplicate-Clone-Copy-Database-using-PHPMyAdmin.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Duplicate-Clone-Copy-Database-using-PHPMyAdmin.webp?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":4462,"url":"https:\/\/phpyouth.com\/blog\/add-administrator-user-in-wordpress-using-mysql\/","url_meta":{"origin":4620,"position":1},"title":"Add Administrator User in WordPress Using MySQL","author":"RK Jajoria","date":"September 8, 2017","format":false,"excerpt":"Friends, In today\u2019s article, we\u2019ll learn how to add an administrator user to WordPress using MySQL. Yesterday, my best friend reached out to me because his WordPress site was hacked, and his admin account was deleted. He asked me how he could add a new administrator without accessing the WordPress\u2026","rel":"","context":"In "MySQL"","block_context":{"text":"MySQL","link":"https:\/\/phpyouth.com\/blog\/category\/web-hosting\/database\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/2.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/2.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/2.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":5000,"url":"https:\/\/phpyouth.com\/blog\/remove-wc_sessions-in-woocommerce\/","url_meta":{"origin":4620,"position":2},"title":"How to Remove wc_sessions in WooCommerce","author":"RK Jajoria","date":"July 4, 2019","format":false,"excerpt":"Hello friends! Today, in this tutorial, we will learn how to remove sessions in WooCommerce. First, we will discuss why we need to remove these sessions from WooCommerce. These sessions make the wp_options table heavy in size. WooCommerce stores the _wc_session_xxx and _wc_session_expires_xxx entries in the wp_options table. There are\u2026","rel":"","context":"In "Plugins"","block_context":{"text":"Plugins","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/"},"img":{"alt_text":"Remove woocommerce sessions","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/07\/Remove-woocommerce-sessions.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/07\/Remove-woocommerce-sessions.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/07\/Remove-woocommerce-sessions.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":4508,"url":"https:\/\/phpyouth.com\/blog\/change-site-language-wordpress\/","url_meta":{"origin":4620,"position":3},"title":"How to change Site language in WordPress","author":"RK Jajoria","date":"September 19, 2017","format":false,"excerpt":"Hello Friends, today we will learn about\u00a0How to change Site language in WordPress. Let me first tell you guys why we wrote this article today. A few days ago, one of my subscribers asked me that he is having a problem in the approval of Google Adsense on his website.\u2026","rel":"","context":"In "Wordpress"","block_context":{"text":"Wordpress","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/1-1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/1-1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/1-1.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":5639,"url":"https:\/\/phpyouth.com\/blog\/create-wordpress-admin-user-through-ftp\/","url_meta":{"origin":4620,"position":4},"title":"Create WordPress Admin User Through FTP","author":"RK Jajoria","date":"July 12, 2022","format":false,"excerpt":"Hello friends, Today in this article, we will learn how to create WordPress admin users through FTP. FTP will help us to create a WordPress Admin User when we don't have any other access. You can explore our FTP tutorial if FTP(File Transfer Protocol) is a new thing to you.\u2026","rel":"","context":"In "Wordpress"","block_context":{"text":"Wordpress","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"Create WordPress Admin User Through FTP","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Create-WordPress-Admin-User-Through-FTP.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Create-WordPress-Admin-User-Through-FTP.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Create-WordPress-Admin-User-Through-FTP.webp?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Create-WordPress-Admin-User-Through-FTP.webp?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4734,"url":"https:\/\/phpyouth.com\/blog\/how-to-enable-php-modules-in-whm\/","url_meta":{"origin":4620,"position":5},"title":"How to Enable PHP Modules in WHM","author":"RK Jajoria","date":"May 2, 2018","format":false,"excerpt":"Hello friends, today we will learn how to enable PHP modules in WHM(Web Host Manager). Many WordPress beginners face this issue while importing demo content on a paid WordPress theme. Sometimes, required PHP modules are not installed or activated by default in cPanel. In this article, we will focus on\u2026","rel":"","context":"In "PHP"","block_context":{"text":"PHP","link":"https:\/\/phpyouth.com\/blog\/category\/tutorial\/php\/"},"img":{"alt_text":"How to Enable PHP Modules in WHM","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2018\/05\/PHP-ZIP-module-banner.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2018\/05\/PHP-ZIP-module-banner.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2018\/05\/PHP-ZIP-module-banner.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts\/4620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/comments?post=4620"}],"version-history":[{"count":0,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts\/4620\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/media\/4626"}],"wp:attachment":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/media?parent=4620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/categories?post=4620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/tags?post=4620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}