Hello.
> 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 recommend you to upgrade to 4.1.12. Marco P$hler <[EMAIL PROTECTED]> wrote: > 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. Default > database: 'report'. Query: 'UPDATE sum_day_key_requests SET sum = sum + > 1 WHERE day = '2005-7-16' AND type = 'redirect' AND client = '1234' AND > channel = '43' AND campaign = '...' AND grouping = 'Singleb$se' AND > `key` = 'Single Berlin' AND afftraf = 'NULL' > > I read the docs and compared charset/collation configuration as you can > see below, but it seems to be the same on both servers. > > any hints welcome ! > > thanks in advance > > Marco > > ============================================================================= > Master: MySQL 4.1.10 > -------------------- > > mysql> show variables like 'coll%'; > +----------------------+-------------------+ > | Variable_name | Value | > +----------------------+-------------------+ > | collation_connection | latin1_swedish_ci | > | collation_database | latin1_swedish_ci | > | collation_server | latin1_swedish_ci | > +----------------------+-------------------+ > 3 rows in set (0.00 sec) > > ps ax | grep mysql > 7349 ? Sl 0:01 /usr/sbin/mysqld --basedir=/ > --datadir=/var/lib/mysql --user=mysql > --pid-file=/var/lib/mysql/HAL2005.pid --skip-locking > --open-files-limit=8192 --port=3306 --socket=/var/lib/mysql/mysql.sock > > (no --default-character-set=... or --default-collation=...) > > /etc/my.cnf doesn't contain any charset or collation information > ============================================================================= > Slave: MySQL 4.1.10 > ------------------- > > mysql> show variables like 'coll%'; > +----------------------+-------------------+ > | Variable_name | Value | > +----------------------+-------------------+ > | collation_connection | latin1_swedish_ci | > | collation_database | latin1_swedish_ci | > | collation_server | latin1_swedish_ci | > +----------------------+-------------------+ > 3 rows in set (0.00 sec) > > ps ax | grep mysql > 23970 pts/0 Sl 0:01 /usr/sbin/mysqld --basedir=/ > --datadir=/var/lib/mysql --user=mysql > --pid-file=/var/lib/mysql/HAL2006.pid --skip-locking > --open-files-limit=8192 --port=3306 --socket=/var/lib/mysql/mysql.sock > > (no --default-character-set=... or --default-collation=...) > > /etc/my.cnf doesn't contain any charset or collation information > > ---- > Marco Poehler > http://www.kontaktlinsen-preisvergleich.de > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
