Changing storage engine in dump file.
- Date: Wed, 12 Aug 2015 18:37:52 +0530
- From: geetanjali mehra <mailtogeetanjali@xxxxxxxxx>
- Subject: Changing storage engine in dump file.
I am in the process of creating a new slave. On my master, there is a mix
of innodb and myisam tables. I want all my tables to be created in innodb
I have planned to change the value of storage engine from innodb to myisam
in dump file itself using sed .
Running that dump file on the slave will create all my tables with innodb.
Is there any implications in doing so. Is this approach correct? Will I
face any problem in syncing the slave?
Thanks in advance.