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én [mailto:[EMAIL PROTECTED] Sent: Thursday, December 09, 2004 10:02 AM To: [EMAIL PROTECTED] 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én. mysql - query - sql -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
