Web lists-archives.com

Changing storage engine in dump file.




Hi,

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
on slave.

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.