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

wowthemesnet affiliates

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