Mário Souto Mário Souto - 5 months ago 46
SQL Question

Unknown character set: 'utf8mb4'

im trying to upload my first wordpress website. Im using the local wordpress.org php my admin and the php my admin from 000webhost. Ive researched this a a lot here and changed all the settings people were saying from utf8mb4 to utf8 but it only caused more errors. I changed everything back to what it was (at least i think so and the error is the same as the beginning now). Anyone knows how i can get around this and import my db to 000.webhost with no errors? the Error is SQL query:

/*!40101 SET NAMES utf8mb4 */;


MySQL said: Documentation

1115 - Unknown character set: 'utf8mb4'


1) The first: If you can control ssh server. Please update mysql version. Your mysql too old. Maybe < 5.5.3.

2) The second: If you can't access ssh. Try to export your database with Mysql version 4.0.

  • With command line mysqldump --compatible=mysql40 -u user -p DB > dumpfile.sql
  • With web access phpmyadmin -> Select Database -> Export -> Custom - display all possible options -> Format-specific options ->

    Database system or older MySQL server to maximize output compatibility with: Select MYSQL40.

  • Change content file .sql you exported

/*!50003 SET character_set_client = utf8mb4 */ ;

to utf8 only.

And replace by Ctrl H in Sublime change all from utf8mb4 => utf8

Hope this helps.