List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 20 2002 7:29pm
Subject:Re: does mysqlimport actually recreate the table schmea as well as import data?
View as plain text  
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
Thread
does mysqlimport actually recreate the table schmea as well as import data?Peter J. Schoenster20 Oct
  • Re: does mysqlimport actually recreate the table schmea as well as import data?Dan Nelson20 Oct