Title: phpmyadmin database import error – #1273
Last modified: April 14, 2017

---

# phpmyadmin database import error – #1273

 *  [hatchbackcreative](https://wordpress.org/support/users/hatchbackcreative/)
 * (@hatchbackcreative)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/phpmyadmin-database-import-error-1273/)
 * I am trying to import a .sql database to another server with phpmyadmin, but 
   am getting the following error. Can you help please? Thank you.
 * Error
    SQL query:
 * CREATE TABLE `wp1q_layerslider` (
 *  `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
    `author` INT( 10 ) NOT NULL DEFAULT‘
   0’, `name` VARCHAR( 100 ) COLLATE utf8mb4_unicode_520_ci DEFAULT ”, `slug` VARCHAR(
   100 ) COLLATE utf8mb4_unicode_520_ci DEFAULT ”, `data` MEDIUMTEXT COLLATE utf8mb4_unicode_520_ci
   NOT NULL , `date_c` INT( 10 ) NOT NULL , `date_m` INT( 10 ) NOT NULL , `schedule_start`
   INT( 10 ) NOT NULL DEFAULT ‘0’, `schedule_end` INT( 10 ) NOT NULL DEFAULT ‘0’,`
   flag_hidden` TINYINT( 1 ) NOT NULL DEFAULT ‘0’, `flag_deleted` TINYINT( 1 ) NOT
   NULL DEFAULT ‘0’, PRIMARY KEY ( `id` ) ) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT
   CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci;
 * MySQL said: Documentation
 * #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [mdshak](https://wordpress.org/support/users/mdshak/)
 * (@mdshak)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/phpmyadmin-database-import-error-1273/#post-9029606)
 * Take the following steps to troubleshoot this issue.
 * Open .sql file on any text file editor and go to “Search and Replace”.
 * Find this “utf8mb4” and replace with “utf8”.
 * It will replace the utf8mb4_unicode_ci to utf8_unicode_ci.
 * Now you go to your PhpMyAdmin (destination) and set the DB collation to utf8_unicode_ci(
   Operations > Collation).
 *  [sinip](https://wordpress.org/support/users/sinip/)
 * (@sinip)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/phpmyadmin-database-import-error-1273/#post-9029716)
 * Server where you’re importing the database doesn’t support unicode 520ci collation.
   You can contact your hosting company and ask them to upgrade MySQL to 5.6 or 
   above in order to support it, or convert the database to “standard” unicode. 
   Here a nice guide – [https://www.peterstavrou.com/fix-unknown-collation-utf8mb4_unicode_520_ci-error/](https://www.peterstavrou.com/fix-unknown-collation-utf8mb4_unicode_520_ci-error/)
    -  This reply was modified 9 years, 1 month ago by [sinip](https://wordpress.org/support/users/sinip/).

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘phpmyadmin database import error – #1273’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [sinip](https://wordpress.org/support/users/sinip/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/phpmyadmin-database-import-error-1273/#post-9029716)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics