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

Our stories delivered in your Inbox

Join our newsletter and get more articles like this in your inbox.
We never spam and you can unsubscribe at any time!

Hey! Since you're here, we'd like to show you something. We've just released a new free Bootstrap template, are you interested?

Yes, show me!

You may also like:

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

Wow Bootstrap Starter Kit - Free Bootstrap Kit

Audio Landing - Free HTML Landing Page

  Keep an eye on what we're doing  
 
    Find us:      

Keep an eye on what we're doing