<div>
That is great. I ve used MySQLAdmin that create the backup (old data dump). Then I have restored it to MySQL 5 and used Angellll's suggestion. Worked like a charm.
</div>


That is great. I ve used MySQLAdmin that create the backup (old data dump). Then I have restored it to MySQL 5 and used Angellll's suggestion. Worked like a charm.

<div>
<div class="content wysiwyg-content">
I have a legacy MySQL 3.x database with the MyISAM engine and I need to export that to a MySQL 5.x server.<br />
<br />
Is it possible to migrate from MyISAM to Innodb?<br />
<br />
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.<br />
<br />
If I were to migrate to InnoDB I would have to change its schema file.<br />
<br />
What is the best, fastest, easiest and safest way to accomplish this task?<br />
<br />
Thanks.
</div>
</div>


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?

Thanks.

MySQL 3.x to 5.x Migration

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.