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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]