sigh
This works:
localhost TRUNCATE t_dmu_history;
Query OK, 0 rows affected (0.41 sec)
localhost LOAD DATA LOCAL INFILE 't_dmu_history.txt' INTO TABLE t_dmu_history
FIELDS TERMINATED BY , (`dm_history_dm_id`,`dm_history_customer_id`);
Query OK, 876211 rows affected (25.16 sec)
Records:
It's been a long time sine I used mysqlimport, but you might want to try:
- using --fields-terminated-by rather than --fields-terminated
- losing (or escaping) the backticks in --columns=
- checking my.cnf to see if the client settings are the same for mysql
and mysqlimport
- checking user
-Original Message-
From: Carsten Pedersen [mailto:cars...@bitbybit.dk]
Sent: Monday, January 03, 2011 1:48 PM
To: Jerry Schwartz
Cc: 'mos'; mysql@lists.mysql.com
Subject: Re: mysqlimport doesn't work for me
It's been a long time sine I used mysqlimport, but you might want to try:
- using