The Issue

If you are here, you are probably getting the error Unknown collation: 'utf8mb4_unicode_ci' when trying to import a database. We will not get into the technical explanation of why this happens, we’ll focus on the solution instead.

The Solution

Forget about the old export file. Create a new one and follow the steps:

  • Choose Custom from Export Method.
  • Scroll down to Format Specific Options and select MYSQL40 at Database system or older MYSQL server to maximize output compatibility
  • Scroll at the bottom, click Go
  • Done!

Screenshot

Now you can import the new generated file. Did this solution work for you? Please let others know by leaving comments below!

Tips & Tricks Tutorials

Let's stay in touch, please! We'll send you stories similar to "How to fix Unknown collation: utf8mb4_unicode_ci" if you join our newsletter. It's free and you can unsubscribe at anytime!

You may also like:

Comments

WowThemesNet membership

We create themes & templates
Take a look at our
newest themes

wow thems Join our free newsletter

Let's keep in touch! Get new themes, updates, discounts and important news for your website straight to your inbox. You can unsubscribe at anytime!

Yes, I'd like to hear about your products and news. Privacy Policy