SELECT * INTO OUTFILE 'file' FROM tbl_name
LOAD DATA INFILE 'file' REPLACE ....
PRIMARY KEY or a UNIQUE index.
REPLACE clause causes old rows to be replaced with new ones when a new row duplicates an old row on a unique key value.
How do I backup data stored in an InnoDB storage engine?
© 2007 John Michael Pierobon