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?