'Illegal mix of collations' Error Occurs When Running Mysqldump

Asked 2 years ago, Updated 2 years ago, 130 views

Attempting to dump an existing database in MySQL on a Windows PC

mysqldump-uroot-p testdb>testdb.dump

When I ran , the following error occurred:

mysqldump Error: 'Illegal mix of collations (utf8_general_ci, CORECIBLE) and (uft8_unicode_ci, CORECIBLE) for operation' = 'when trying to dump tablespaces

I looked up a similar problem online and checked the database character code in mysql client as follows, but it didn't look like a mix of utf8_general_ci and utf8_unicode_ci

mysql>show variables like 'char%';
variable_name | Value
character_set_clinet | uft8
character_set_connection | utf8
character_set_database | utf8
character_set_filesystem | utf8
character_set_results | utf8
character_set_server | utf8
character_set_system | utf8
character_sets_dir | c:\Program Files\MySQL\MySQL Server 8.0\share\charsets\
mysql>show variables like 'coll%';
Variable_name | Value
collation_connection | utf8_unicode_ci
collation_database | utf8_unicode_ci
collation_server | utf8_unicode_ci
mysql>show table status from testDB;

(Omitted, but verified that all tables are utf8_unicode_ci)

MySQL version
mysqld:ver 8.0.16 for win64 on x86_64
mysql:ver 8.0.16 for win64 on x86_64

Where is the problem?

mysql

2022-09-30 21:45

1 Answers

By the way, is there any difference between mysql and mysqldump? Specifically, check my.cnfor my.ini to see if the settings in sections such as [mysql][mysqldump] match.


2022-09-30 21:45

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.