> Please, send the output of the following statement executed both on
> master and slave:
>
> show variables like '%char%';
mysql> show global variables like 'c%';
+--++
| Variable_name| Value |
+-
Am Dienstag, den 09.08.2005, 17:57 +0400 schrieb Alexey Polyakov:
> If charsets/collations are not set explicitly in my.cnf, server could
> be using ones specified during compilation.
> To check charsets and collations on the running server do:
> show global variables like 'c%';
Thanks.
I execute
Hi,
I try to replicate an existing database to a new server and run into
trouble with collations. Maybe somebody can help me.
Existing DB-Server (Master):
MySQL Version 4.1.12
ca. 100 GB Database size.
New DB-Server (Slave):
MySQL Version 4.1.12
Here is what I did to get the replication up and
> > Illegal mix of collations (latin1_bin,IMPLICIT) and
> > (utf8_general_ci,COERCIBLE) for operation '='' on query. Default
>
> What default charset do your slave's tables have? The coercibility
> value of system constants has changed in 4.1.11. Though it seems not
> related to your problem I re
Hello List,
I've tried to set up a slave from an existing master using innobackup.
The copy of the database was successful, but when I started the
replication, the following error occured:
Illegal mix of collations (latin1_bin,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='' on query.
