CHARACTER SET 'UTF8MB4_0900_AI_CI' CANNOT BE USED IN CONJUNCTION WITH 'BINARY' IN CALL TO REGEXP_LIKE

mojamoi

Well-Known Member
Jul 23, 2007
195
0
66
CHARACTER SET 'UTF8MB4_0900_AI_CI' CANNOT BE USED IN CONJUNCTION WITH 'BINARY' IN CALL TO REGEXP_LIKE
While restoring mysql i get above error?

What to do??
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,028
313
cPanel Access Level
Root Administrator
Hey there! While this doesn't appear to be a cPanel issue, most discussion around this error involves users moving data from a previous version to MySQL 8. Is that the case here? If so, there are some additional details on how MySQL handles that here:


but it would be best to restore the data to the same MySQL server type of possible.