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
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.
© 2024 OneMinuteCode. All rights reserved.