Hi Rob, LOAD DATA INFILE is not a very verbose command. It doesn't spill out the exact root cause of the error. Forgive me, if I seem to be wrong for anybody who had a different opinion.
mysqlimport is a wrapper around LOAD DATA INFILE with a lot of command line options. You might try your luck using the mysqlimport command which does the same for you. But I am not sure if it really helps you with more verbose output. The problem might be due to any of the following problems: -> The data in the file needs to be in a format that mysql understands. With mysqlimport you can specify the column and record delimiters as required. -> Escape characters need to be defined when you do a mysqlimport so that the data is not mistaken as a delimiter by mysql. -> Also make sure that there are no foreign key violations in your target database. Regards, Goutham S Mohan --------------- Software Engineer, Hewlett Packard --- rob byrne <[EMAIL PROTECTED]> wrote: > I am trying to load data from a text file into a > table using the Load data > infile statement. No matter how I change data types > I seem only able to load > in the first row of data into the MySQL table and no > more. I have not been > able to trach the source of this error or the cause > of it? Does anyone know > the cause so I can fix it? > RB > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]