Goutham Thanks for your help. The problem in this case was line endings. I use an Apple g4 for web work on system 10.2. By default BBEdit uses macintosh line endings. MySQL does not recognize them. As soon as I changed the textfile format to unix line endings, it imported the data without any trouble at all. I take your point about mysql import and the nature of this command. The only reason I am using is that at the present time I do not have the time to reconfigure my server to make use of other ways of importing text. Thanks for your comments RB
On 21/12/04 1:31 AM, "Goutham S Mohan" <[EMAIL PROTECTED]> wrote: > 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]
