I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
script. I notice an option for mysqlimport is not working or im doing it
wrong.

This works with LOAD DATA INFILE  :
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES"


but when i try:

mysqlimport --ignore-lines=2 -uroot -ppassword month 0114.txt

It says unknown option "--ignore-lines="? Am i doing this wrong?

Also will mysqlimport work only if the .txt file is the same name as the
table in the db( mine is month.Jan04, but the files are always mmdd.txt)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to