Re: best way to convert to InnoDB?

[Isart montane]

Hi Matthew,

what I do when I have this type of problems is follow this procedure:
1) create a new table with the updated structure "new_innodb_table"
2) insert in chunks the data from the old table to the new structure. As it's inserting in chunks this process does not affect the server performance, and can be done in a few days if required.
insert into new_innodb_table select * from old_myisam_table where id between 1 and 1000;
insert into new_innodb_table select * from old_myisam_table where id between 1001 and 2000;
insert into new_innodb_table select * from old_myisam_table where id between 2001 and 3000;
.....
.....
.....
3) when all the rows are inserted, rename the new table
RENAME new_innodb_table TO old_myisam_table.

4) Done

Isart Montane Mogas

-----------------
Isart Montane Mogas
isart.montane{at}gmail.com