From: Robert Klemme <shortcutter@...>
Date: 2006-04-20T18:24:41+09:00
Subject: Re: Database re-structuring

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/