Database import Error | WordPress.org

Resolved jeffreybeckers
(@jeffreybeckers)

10 years, 6 months ago

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/

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

Plugin Contributor DNutbourne
(@dnutbourne)

10 years, 6 months ago

Hi,

Could you send a screenshot or copy of the error that you are receiving?

Thread Starter jeffreybeckers
(@jeffreybeckers)

10 years, 6 months ago

http://www.jeffreybeckers.com/wp-content/uploads/Schermafdruk-2015-11-05-12.34.22.jpg

Plugin Contributor DNutbourne
(@dnutbourne)

10 years, 6 months ago

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.

3 replies
2 participants
Last reply from: DNutbourne
Last activity: 10 years, 6 months ago
Status: resolved