Converting to InnoDB

[Proware]

I have enabled InnoDB in MySQL but have a question.

Do I also need to convert all / individual files to have an InnoDB table type instead of MyIsam?

[dstrickler]

While not expert on this, I switched today from InnoDB from MyISAM, and had to dump and reload our tables. Note that after the dump, I edited the dump file and changed all text that said "MyISAM" to "InnoDB". Then I reloaded the data.

That worked just fine, and even seemed to re-create the indexes, etc.

Note, for 71MB of dumped data, it took a few hours to import on a rockin' new server.

[dstrickler]

I found a short, but well written article on the upgrade: http://software.newsforge.com/softwa...1.shtml?tid=72

[hypo.jb]

While not expert on this, I switched today from InnoDB from MyISAM, and had to dump and reload our tables. Note that after the dump, I edited the dump file and changed all text that said "MyISAM" to "InnoDB". Then I reloaded the data.

That worked just fine, and even seemed to re-create the indexes, etc.

Note, for 71MB of dumped data, it took a few hours to import on a rockin' new server.

You could have taken a snapshot (mysqldump) of the DB in myISAM then created an empty DB using the InnoDB engine then ran the script...

and 71MB = few hours??? on a new server? can you describe what you were doing that it took such a long time?

[dstrickler]

You could have taken a snapshot (mysqldump) of the DB in myISAM then created an empty DB using the InnoDB engine then ran the script...

and 71MB = few hours??? on a new server? can you describe what you were doing that it took such a long time?

When I ran it the 2nd time (after some minor InnoDB tuning params), it took under 4 minutes. ;-)

Server is a Compaq DL360. Dual 3.6ghz Xenon CPUs, 5GB of RAM, SCSI RAID 0 (just a mirror). Running MySQL5, Ubuntu, and PHP5. Oh and v4.5c of Sugar ;-)