load data into 2 tables and set id

[J S]

Hi,

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_TABLE
user_id   date_time   url_id   size

and

URL_TABLE
url_id   url   category


The data values I have for each record are:

user_id   date_time   size   url   category

for example:

u752359   2004-04-02 12:33:04   3403   http://www.mysql.com/index.html   
business

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?

Many thanks,

js.

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger