Just cross posting this to documentation list. Indeed this would be a good page. If someone would care to create the entire SQL script required to make duplicate Innodb tables - and the corresponding INSERT INTO ... SELECT * FROM queries, I would be happy to put it in the snippets page (and/or elsewhere). I would do this myself - but I think this requires an expert's hand (i.e. someone that has a actually done the conversion themselves). andre puregin wrote:
This might be a good "SQL snippet":
Cheers, Djun
See here: http://dev.mysql.com/doc/refman/4.1/en/converting-tables-to- innodb.html
"The fastest way to alter a table to InnoDB is to do the inserts directly to an InnoDB table. That is, use ALTER TABLE ... TYPE=INNODB, or create an empty InnoDB table with identical definitions and insert the rows with INSERT INTO ... SELECT * FROM ...."
Seems a script with show tables, then alter table does the trick.
InnoDB involves creating a table space a la Oracle though, so there is more preparatory work that has to be done.
___________________________________________________________ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com