[thelist] MySQL: transfer data to table with different structure?

[Hassan Schroeder]

On Sun, Mar 9, 2008 at 11:08 AM, Fred Jones <fredthejonester at gmail.com> wrote:

>  2. Write a script that fetches the data from the old DB and then writes
>  out (to a text file) the SQL statements to INSERT the data into the new
>  DB.

No need to recreate that wheel -- it's called 'mysqldump'  :-)

Then just search/replace all the table names in that dump file and
you're ready to re-import.

HTH!
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com