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
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
Change content file .sql you exported
/*!50003 SET character_set_client = utf8mb4 */ ;
And replace by Ctrl H in Sublime change all from
Hope this helps.