MySQL Utilities 1.4 Manual  /  ...  /  How Can I Make a Copy of a Database and Change the Storage Engine?

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.


User Comments
Sign Up Login You must be logged in to post a comment.