CodingForums.com - View Single Post

Old Pedant · 10-13-2012, 01:36 AM

One easy thing to do: dump the old one, getting the dump as MyISAM.

On the new site, create a TEMPORARY database and import the MyISAM tables to *THAT* database. [If the dump file from the old DB specifies the database name, just use an editor to change it in the dump file.]

Now just construct a query that will copy the data from the temp database table(s) into the InnoDB tables in the main database.

Might be tedious if there are lots of tables and lots of fields, but probably lees work than any other way.

When done, you can just drop the temp database.

10-13-2012, 01:36 AM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,248 Thanks: 59 Thanked 3,998 Times in 3,967 Posts	One easy thing to do: dump the old one, getting the dump as MyISAM. On the new site, create a TEMPORARY database and import the MyISAM tables to THAT database. [If the dump file from the old DB specifies the database name, just use an editor to change it in the dump file.] Now just construct a query that will copy the data from the temp database table(s) into the InnoDB tables in the main database. Might be tedious if there are lots of tables and lots of fields, but probably lees work than any other way. When done, you can just drop the temp database. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.