主从MySQL复制与列名中的特殊字符？

我试图得到一个简单的主从MySQL复制运行，但我有一些奇怪的错误时，使用LOAD DATA INFILE：

110908 23:59:42 [ERROR] Slave SQL: Error 'Unknown column 'N°_Site' in 'field list'' on query. Default database: 'b4_sites'. Query: 'LOAD DATA INFILE '/tmp/SQL_LOAD-116-4-6441.data' IGNORE INTO TABLE `cellule_1` FIELDS TERMINATED BY ';' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`Region`, `V2G3G`, `Lac`, `CI`, `bsc_rnc`, `N°_Site`, `Constructeur`)', Error_code: 1054 110908 23:59:42 [Warning] Slave: Unknown column 'N°_Site' in 'field list' Error_code: 1054 110908 23:59:42 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000002' position 68303896 

我们有主服务器和从服务器上运行的Ubuntu Server 10.04 LTS 。 相同的MySQL版本mysql-server-core-5.1 – 5.1.41-3ubuntu12.10 。 几乎相同的MySQLconfiguration（我可以发布，如果需要）没有什么特别的幻想。

我可以看到，表中有一个字段的名称中有一个特殊字符，这显然会引发错误，但奇怪的是查询在主服务器上执行时没有错误。

两台服务器上的字符集 – master：

• 怎么mysql复制
• 绑定从属创build域没有任何logging
• MySQL init.d脚本具有不同的configuration文件
• Memcache Master和奴隶
• 具有PostgreSQL复制的容错DBMail – 我在这里有什么select？

 mysql> show variables like "char%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec) 

奴隶：

 mysql> show variables like "char%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec) 

欢迎任何帮助，提前致谢

 [client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set=UTF8 ... 

  mysql> SET NAMES UTF8;