Hi everyone, I am looking for some suggestions here.

I've got an older mysql database, one table, dumped into a SQL file.

I want to use this data in my new database, only this time I want the 
data to go into multiple tables instead of one big table.

I was thinking of writing a script to parse the SQL file and based on 
each entry, put the information where it needs to go.  I also thought of 
feeding the SQL file into my new database, and write a script that went 
thought each row in the data of old table (with a SELECT *) and figured 
out where to put it in the new tables.

Is this an insane way to do things?  I have a feeling I am doing a lot 
more work than necessary.  Does anyone have any suggestions?

-- 
Posted via http://www.ruby-forum.com/.