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