Error 1:error Unknown Character set: ' Utf8mb4 '
The UTF8MB4 encoding set supports emoticons and believes that people who have processed social network data are aware of it. This mysql5.5 supports the UTF8MB4 encoding set later, so it can only uninstall 5.1, upgrade 5.5
Set the Default-character-set = Utf8mb4 in MySQL my.cnf, set the UTF8MB4 in each [], or set it up in this setting, more convenient and efficient when building a database or datasheet
[Client]
Default-character-set = Utf8mb4
[MySQL]
Default-character-set = Utf8mb4
[Mysqld]
Character-set-client-handshake = FALSE
Character-set-server = Utf8mb4
Collation-server = Utf8mb4_unicode_ci
init_connect= ' SET NAMES utf8mb4 '
Error 2:
#1064in for ' using BTREE, KEY ' Authorid ' (' Authorid ') using BTREE, KEY ' Dateline ' (' Datel' at line
After looking for the MySQL version of the issue, the imported library is the server version:5.0.18, the exported library 5.1.45. Open the exported MySQL file and find a similar
KEY ' Authorid ' (' Authorid ') USING BTREE
Modified into
KEY ' Authorid ' USING BTREE (' Authorid ')
MySQL import backup. sql file times wrong summary (still to be perfected)