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/