Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

WordPress

Joe Li
Joe Li
8,104 Points
Posted by Joe Li
Joe Li
8,104 Points

Wordpress Database Help!

Hey Guys,

I tried to import my DB into PHP MYAdmin and it keeps giving me the following error.

Error SQL query:

--

-- Database: kaizen

--

-- Table structure for table wp_commentmeta

CREATE TABLE wp_commentmeta (

meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT , comment_id BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0', meta_key VARCHAR( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL , meta_value LONGTEXT COLLATE utf8mb4_unicode_ci, PRIMARY KEY ( meta_id ) , KEY comment_id ( comment_id ) , KEY meta_key ( meta_key ( 191 ) ) ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci AUTO_INCREMENT =1;

MySQL said: Documentation

1273 - Unknown collation: 'utf8mb4_unicode_ci'

Does anyone know where to start with this??

Thanks,

Joe

1 Answer

Gustavo Zimmermann
Gustavo Zimmermann
6,857 Points
Gustavo Zimmermann
Gustavo Zimmermann
6,857 Points

It's a Mysql version problem, you can try to upgrade mysql on the origin, best option you can downgrade the destination mysql to match the version of the origin or if you use phpmyadmin there is an custom option on "Format-specific" to resolve the issue