Mysql database import SQL error (unknown collation: ‘utf8mb4_ 0900_ ai_ ci’ )

Time：2021-3-6

Mysql database import SQL error (unknown collation: 'utf8mb4_ 0900_ ai_ ci' )
Mysql database import SQL error (unknown collation: 'utf8mb4_ 0900_ ai_ ci' )
Error reason: high version database (8.0) transfers SQL file and imports low version database (5.7)

terms of settlement:

Scheme 1: upgrade Mysql to a higher version

Scheme 2: the SQL file to be imported, the

utf8mb4_0900_ai_ciReplace all withutf8_general_ci

utf8mb4Replace withutf8

Re execute SQL file

Tags: , , , ,

Recommended Today

Rust and python: why rust can replace Python

In this guide, we compare the rust and python programming languages. We will discuss the applicable use cases in each case, review the advantages and disadvantages of using rust and python, and explain why rust might replace python. I will introduce the following: What is rust? What is Python? When to use rust When to […]