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]