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

3.1.3.1 Objectives
3.1.3.2 Example Execution
3.1.3.3 Discussion
3.1.3.4 Permissions Required
3.1.3.5 Tips and Tricks
3.1.3.6 Risks

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.