I have a legacy MySQL 3.x database with the MyISAM engine and I need to export that to a MySQL 5.x server.
Is it possible to migrate from MyISAM to Innodb?
Also, what is the best approach for that? MySQLAdmin allows you to create a backup file whichI think it is like a SQL dump with a bunch of SQL statements.
If I were to migrate to InnoDB I would have to change its schema file.
What is the best, fastest, easiest and safest way to accomplish this task?