Hi all,
I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze
version), when importing data from a file with semicolon-separated data, I
get random default values for the datetime fields. This turns the data
obviosly unusable.

The same import on the same machine but with the 4.0.12 version of the
server is totally bug free.

Does anyone have experience on this sort of problems?

Leonardo J. Belén.


mysql - query - sql


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

At the end of your csv file, are you including ,\n ?

If you are using mysql on windows and LOAD DATA IN FILE you need to
include unix line breaks at the end of each line, else the data will
be loaded wacky...so if each line looks like this:

"","value1","value2","value3","value4"

change it to this: (on each line, search replace maybe?)

"","value1","value2","value3","value4",\n

phpninja

-----Original Message-----
From: Leonardo Javier Bel=E9n [mailto:lbelen (AT) afip (DOT) gov.ar]=20
Sent: Thursday, December 09, 2004 10:02 AM
To: mysql (AT) lists (DOT) mysql.com
Subject: Problem importing data

Hi all,
I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze
version), when importing data from a file with semicolon-separated data, I
get random default values for the datetime fields. This turns the data
obviosly unusable.

The same import on the same machine but with the 4.0.12 version of the
server is totally bug free.

Does anyone have experience on this sort of problems?

Leonardo J. Bel=E9n.


mysql - query - sql


--

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3...ie.nctu.edu.tw