CREATE TABLE `load` ( `Timestamp` datetime NOT NULL, `Value` double unsigned NOT NULL, `QUALIF` varchar(45) NOT NULL, `DS` varchar(45) NOT NULL, `Platform` varchar(45) NOT NULL, `Object` varchar(45) NOT NULL, `Computer` varchar(45) NOT NULL, PRIMARY KEY (`Timestamp`,`QUALIF`,`DS`,`Object`,`Computer`) ); --exec touch $MYSQLTEST_VARDIR/load.txt --exec $MYSQL_IMPORT --ignore --fields-terminated-by=\; test $MYSQLTEST_VARDIR/load.txt