I need some help please! I have 60GB of proxy logs to parse and load into a
mysql database. I've written a parsing script but I'm stuck now on how to
load the data in.
I have a database called PROXY_LOG with 2 tables:
user_id date_time url_id size
url_id url category
The data values I have for each record are:
user_id date_time size url category
u752359 2004-04-02 12:33:04 3403 http://www.mysql.com/index.html
The problem is I'm not sure how to load the data into the 2 tables and set
the url_id. Could anyone point me in the right direction please?
It's fast, it's easy and it's free. Get MSN Messenger today!