3.1.3. How Can I Make a Copy of a Database and Change the Storage Engine?

Sometimes you may have need to create a copy of a database but
change the storage engine of all tables to another engine.

For example, if you are migrating your database to InnoDB (a
wise choice), you can copy the database to a new database on a
new server and change the storage engine to InnoDB. For this, we
can use the mysqldbcopy utility.