Title: Database import Error
Last modified: August 30, 2016

---

# Database import Error

 *  Resolved [jeffreybeckers](https://wordpress.org/support/users/jeffreybeckers/)
 * (@jeffreybeckers)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/database-import-error-2-2/)
 * Hi,
 * I have a backup of my website and i want to duplicate it to a testserver for 
   updating. When i import the database that is backedup, i get an error.
 * I import the .gz file with the following settings:
    Character set of the file:
   utf-8 Format: SQL
 * Please help.
 * Thx
 * [https://wordpress.org/plugins/updraftplus/](https://wordpress.org/plugins/updraftplus/)

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

 *  Plugin Contributor [DNutbourne](https://wordpress.org/support/users/dnutbourne/)
 * (@dnutbourne)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/database-import-error-2-2/#post-6715383)
 * Hi,
 * Could you send a screenshot or copy of the error that you are receiving?
 *  Thread Starter [jeffreybeckers](https://wordpress.org/support/users/jeffreybeckers/)
 * (@jeffreybeckers)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/database-import-error-2-2/#post-6715437)
 * [http://www.jeffreybeckers.com/wp-content/uploads/Schermafdruk-2015-11-05-12.34.22.jpg](http://www.jeffreybeckers.com/wp-content/uploads/Schermafdruk-2015-11-05-12.34.22.jpg)
 *  Plugin Contributor [DNutbourne](https://wordpress.org/support/users/dnutbourne/)
 * (@dnutbourne)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/database-import-error-2-2/#post-6715447)
 * Hi,
 * The error means that the MySQL server that you are restoring on does not support
   the collation used by your database. WP from versions 4.2 onwards uses utf8mb4_unicode_ci
   by default, so the MySQL server needs to be able to support that, if you want
   to use a backup that was using that character set.
 * If possible, the best solution would be to upgrade the test MySQL server to version
   5.5.3 or higher.

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

The topic ‘Database import Error’ is closed to new replies.

 * ![](https://ps.w.org/updraftplus/assets/icon-256x256.jpg?rev=1686200)
 * [UpdraftPlus: WP Backup & Migration Plugin](https://wordpress.org/plugins/updraftplus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/updraftplus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/updraftplus/)
 * [Active Topics](https://wordpress.org/support/plugin/updraftplus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/updraftplus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/updraftplus/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [DNutbourne](https://wordpress.org/support/users/dnutbourne/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/database-import-error-2-2/#post-6715447)
 * Status: resolved