Question about load data infile command

[George Jewell]

Hello,

I have two tables with identical structure. One is for archived records, one for temporary use. I would like to use 'select into outfile...' to export the temporary records to a file, and then use 'load data infile' to import into the archive table. I have a primary key field (record_id), and this causes a duplicate key error when trying to import. I looked at the REPLACE and IGNORE switches, but I need to preserve ALL records not replace or ignore ones with a duplicate key. Am I looking at the wrong solution here? Thanks.