mysqlimport很令人头疼的错误

jacky22109

------------------------------------------------------------------------------------------------------
       128.0.0.0,128.6.255.255,2147483648,2147942399,US,United States
       128.7.0.0,128.7.255.255,2147942400,2148007935,DE,Germany
       128.8.0.0,128.11.62.99,2148007936,2148220515,US,United States
       128.11.62.100,128.11.62.119,2148220516,2148220535,AU,Australia
       128.11.62.120,128.11.96.31,2148220536,2148229151,US,United States
       128.11.96.32,128.11.96.63,2148229152,2148229183,CA,Canada
       128.11.96.64,128.15.255.255,2148229184,2148532223,US,United States
       128.16.0.0,128.16.255.255,2148532224,2148597759,GB,United Kingdom
       128.17.0.0,128.38.255.255,2148597760,2150039551,US,United States
       128.39.0.0,128.39.255.255,2150039552,2150105087,NO,Norway
       128.40.0.0,128.41.255.255,2150105088,2150236159,GB,United Kingdom
-------------------------------------------------------------------------------------------------------
mysql> select * from geoip where start_ip='128.0.0.0';
+-----------+---------------------+-----------------+------------------+----+------------------+
| start_ip     | stop_ip                 | start_long     | stop_long       | cc  | cn                   |
+-----------+---------------------+-----------------+------------------+----+------------------+
| 128.0.0.0    | 128.6.255.255    | 2147483647 | 2147483647   | US | United States |
+-----------+---------------------+----------------+-------------------+----+------------------+
1 row in set (0.09 sec)
-------------------------------------------------------------------------------------------------------
在文本文件里我是用逗号分隔的,所以我导入数据库的语句是
mysqlimport  --fields-terminated-by=, aaa aaa.sql
数据导入了以后,我发现数据库里的start_long字段的数据是2147483647,它的start_ip是128.0.0.0(全部都是不重复的),但我的文本文件第一行对应的start_long是2147483648,而且后面还有五六万行的数据也都变成2147483647了,这是怎么回事????其实前面还有两万多行的记录,我在文本里都删除了!错误从128.0.0.0这条记录开始的!

求高手教教我该怎么做????我的数据库是mysq!!!!万分感谢!

[ 本帖最后由 jacky22109 于 2006-8-24 13:22 编辑 ]

sun9527

mysqlimport  -dlL --fields-terminated-by=','   aaa   aaa.txt
我都是这样导的。

jacky22109

sun9527  

首先谢谢你的回复.

我自己已经解决了，是我的数据库设置的范围太小了，我用的是int的.结果那个值已经超出int的范围了，我改成bigint就ok了.