Project

General

Profile

« Previous | Next » 

Revision 9660

Added by Aaron Marcuse-Kubitza over 11 years ago

lib/sh/db.sh: mysql_import(): in append mode, use LOAD DATA IGNORE to allow inserting duplicate rows

View differences:

lib/sh/db.sh
138 138 
	ssh2local # ssh does not tunnel nonstandard fds
139 139 
	mysql_ANSI "$@" 40<&0 <<EOF
140 140 
LOAD DATA LOCAL INFILE '/dev/fd/40'
141 
INTO TABLE $table_esc
141 
${append:+IGNORE }INTO TABLE $table_esc
142 142 
$mysql_load_data_format
143 143 
IGNORE 1 LINES
144 144 
EOF

Also available in: Unified diff