Title: Not Able to Import Database
Last modified: December 28, 2016

---

# Not Able to Import Database

 *  [kennethrjonesstem](https://wordpress.org/support/users/kennethrjonesstem/)
 * (@kennethrjonesstem)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/not-able-to-import-database/)
 * _[ Moderator note: [moved to Fixing WordPress](https://wordpress.org/support/topic/please-use-how-to-and-troubleshooting-if-you-have-problems-after-installation/).]_
 * I am trying to move my blog from GoDaddy WordPress Hosting to CPanel Hosting.
   I installed WordPress on the new server, and replaced the wp_content directory.
   I was having some database issues, so I just deleted all of the tables in the
   new installation, and then tried to import my database backup from the WordPress
   Hosting.
 * I keep getting an error: 1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
 * I’ve been looking online and I’m not able to find a solution to fix the problem,
   but the best I can come up with, is that the WordPress Hosting was using 5.6 
   and CPanel is using 5.5.
 * I contacted GoDaddy and they told me it would be impossible to move the database,
   and they refuse to upgrade my server to 5.6.
 * So I have no idea what I’m supposed to do.

Viewing 1 replies (of 1 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [9 years, 4 months ago](https://wordpress.org/support/topic/not-able-to-import-database/#post-8596876)
 * edit your import file (make a copy first) and change `‘utf8mb4_unicode_520_ci`
   to `utf8_ci`, then try importing it.

Viewing 1 replies (of 1 total)

The topic ‘Not Able to Import Database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/not-able-to-import-database/#post-8596876)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics