Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
A
A
Anton Pashchenko2022-04-20 16:11:56
MySQL
Anton Pashchenko, 2022-04-20 16:11:56

How to fix mysqldump "illegal mix of collations (utf8_general_ci,COERCIBLE) and (utf8_unicode_ci,COERCIBLE)" error?

When trying to create a dump, an error occurs:

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

Actually the question is how to fix it, where and how to change "collations"?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
N
NyxDeveloper2021-05-04 16:15:55
How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False? 4Reply
Q
Questions00012021-05-07 16:07:05
How to bypass intrusive Youtube ads? ad blockers don't help. You need to switch to a paid plan to stop ads. What can be done? 4Reply
G
GaserV2017-06-24 02:43:34
How to return the user who sent the message in Laravel? 5Reply
S
synapse_people2021-05-17 11:49:28
What should be the gt files for learning? 0Reply
A
Alexey Nikolaev2017-07-04 20:52:42
How to remove push effect from input button in IE? 4Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question