MySQL Forums
Forum List  »  Newbie

Re: Importing Tomcat Access Log
Posted by: Phillip Ward
Date: February 04, 2015 06:29AM

Quote

The fields are space delimited and so are the lines.
So how is anybody (or anything?) supposed to know where one field/row ends and another begins? Are you really, really sure that they're spaces?

What does the table look like? ("show create table X \g")
What does the file look like (a couple of sample rows will do).
How are you loading the data?

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
February 03, 2015 05:01PM
Re: Importing Tomcat Access Log
February 04, 2015 06:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.