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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
