I've tried to import a comma delimited text file into a mysql database using mysqlimport as well as the load datafile command. Either way, It loads exactly 127 records, and keeps the correct information for the first two fields, but gives the value of 127 for the remaining two fields. Any ideas? There are about 900 records in the text file.