Can't export a default database from Cpanel to Sequal pro or Adminer

Support
1

I’m unable to import an existing database from my Cpanel into local.

I’ve created a new database and altered it to the different uft-8mb4 codes, but the Sequel Pro and Adminer both give me the following warning. The database is running fine on the live site.

[ERROR in query 7] Unknown collation: 'utf8mb4_unicode_520_ci’
Import cancelled!

Any ideas on how to fix this without converting the database to utf-8?

2

Yup! When you set up your site in Local make sure it’s running MySQL 5.6 instead of 5.5.

3

Works perfectly, is there anyway to update the mysql version once a site is created?

4

Not at the moment, but we’ll probably add that down the road :slight_smile: