1 mysqlimport 导入文本乱码，其实只要保证数据库、操作系统、文本文件的字符集一致，应该就不会有乱码：
CREATE TABLE `trinfo` (
`s_id` varchar(50) NOT NULL,
`o_code` varchar(255) NOT NULL,
`t_time` datetime default NULL,
`eser_id` int(18) default NULL,
`pid` varchar(4000) NOT NULL,
`inkeyword` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
[root@db mysql]# export LANG='SIMPLIFIED CHINESE_CHINA.UTF-8'
[root@db mysql]# echo $LANG
SIMPLIFIED CHINESE_CHINA.UTF-8
[root@db mysql]#
[root@db mysql]#
[root@db mysql]# mysqlimport --user=root --password=xxxx --fields-enclosed-by='"' --fields-terminated-by=',' --default-character-set='utf8' market /var/lib/mysql/tinfo.txt
2 Mantis提交BUG时报错：
Mantis提交BUG时报错，报错信息如下：
APPLICATION ERROR #401
数据库查询失败。数据库返回的错误信息是：#1062: Duplicate entry '5632' for key 1 查询语句：INSERT INTO mantis_bug_table
( project_id,reporter_id, handler_id,duplicate_id,
priority,severity, reproducibility,status,
resolution,projection, category_id,date_submitted,
last_updated,eta, bug_text_id,
os, os_build,platform, version,build,
profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version,
target_version, due_date
)
VALUES
( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
首先：select count(*) from mantis_bug_table;
然后：select max(id) from mantis_bug_table;
再 ： show create table mantis_bug_table;
发现id值都是正常的，应该是表的字典信息有问题，导致Duplicate entry '5632' for key 1 ， repair table mantis_bug_table解决问题：
mysql> select count(*) from mantis_bug_table_tmp;
+----------+
| count(*) |
+----------+
| 5410 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from mantis_bug_table;
+----------+
| count(*) |
+----------+
| 5410 |
+----------+
1 row in set (0.00 sec)
mysql> repair table mantis_bug_table;
+-----------------------------+--------+----------+------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+--------+----------+------------------------------------------+
| bugtracker.mantis_bug_table | repair | warning | Number of rows changed from 5410 to 5411 |
| bugtracker.mantis_bug_table | repair | status | OK |
+-----------------------------+--------+----------+------------------------------------------+
2 rows in set (0.10 sec)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/758322/viewspace-694606/ ，如需转载，请注明出处，否则将追究法律责任。
