2006/4/19, Dick Dishkuvek <dishkuvek / 0xf00d.com>:
> 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.

> 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?

Since mysql 5 you can also write a stored procedure that will read the
table with a cursor and distribute the data to several tables. 
Disclaimer: haven't used mysql stored procedures yet so I don't know
how mature they are.

Kind regards

robert


--
Have a look: http://www.flickr.com/photos/fussel-foto/