From: Dan Nelson
Date: October 20 2002 7:29pm
Subject: Re: does mysqlimport actually recreate the table schmea as well as import data?
List-Archive: http://lists.mysql.com/mysql/122717
Message-Id: <20021020192951.GE66757@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 20), Peter J. Schoenster said:
> A cohort wrote a script to import tab delimited files. He uses
> mysqlimport. He uses the -d option to ONLY empty the data from the
> table before importing the new data. My cohort believes that
> mysqlimport is also dropping the table and then recreating the table
> from somewhere and then inserting the new data. And the problem
> according to him is that apparently MySQL is using some older version
> of the table which has a different column structure so that when the
> new data is imported it goes into the wrong columns.

mysqlimport -d does a "DELETE FROM table", which simply removes rows. 
To make sure that the data is pulled into the correct fields, you
should use the -c option to mysqlimport and explicitly list the columns
in the same order your input file has them.

-- 
	Dan Nelson
	dnelson@stripped