Maybe it's problem with end_of_line symbol.
You could use PHP to insert records directly into db.
----- Original Message -----
From: Irmund Thum <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 2:30 PM
Subject: mysqlimport - LOAD DATA LOCAL INFILE
> for my JavaScript online tutorial
> http://it97.dyn.dhs.org/JavaScript/JS_tutorial/bstat/navobj.html
> I want to use a mysql table to give the visitor the choice making
> a SQL query instead seeing static text.
> The records on the site are exported to a text file,
> but mysql imports only 27:
> a)
> mysqlimport --local --fields-terminated-by="#" mozilla javascript.txt
> mozilla.javascript: Records: 137 Deleted: 0 Skipped: 110 Warnings: 89
> b)
> LOAD DATA LOCAL INFILE '/Dora/javascript.txt' INTO TABLE javascript
> FIELDS TERMINATED BY '#' LINES TERMINATED BY '\n' ;
> Query OK, 27 rows affected (0.01 sec)
> Records: 137 Deleted: 0 Skipped: 110 Warnings: 89
>
> example:
> Mozilla/2.02 (X11; I; OSF1 V3.2 alpha)#Mozilla#2.02 (X11; I; OSF1 V3.2
> alpha)#Netscape# # #x#-#-#-#
> Mozilla/3.0 (X11; I; SunOS 5.5.1 sun4u)#Mozilla#3.0 (X11; I; SunOS 5.5.1
> sun4u)#Netscape#undef.#undef.#x#x#-#-#
> Mozilla/3.0 (X11; I; SINIX-N 5.43 RM400)#Mozilla#3.0 (X11; I; SINIX-N
> 5.43 RM400)#Netscape#undef.#undef.#x#x#-#-#
> Mozilla/3.0SC-SGI (X11; I; IRIX 6.2 IP22)#Mozilla#3.0SC-SGI (X11; I;
> IRIX 6.2 IP22)#Netscape#undef.#undef.#x#x#-#-#
>
> the first 2 rows become imported,
> the next 2 not and so on.
> I can't see any difference.
> Any other method to try, any hint?
> tia
> i.t
>
> --
> Irmund Thum
> +49 179 6998564
> +49 6374 992541
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
