geetanjali mehra Changing storage engine in dump file.
Aug 12, 2015; 18:37
geetanjali mehra
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.
Aug 12
Johan De Meersman Re: Changing storage engine in dump file.
Aug 12, 2015; 15:21
Johan De Meersman
Re: Changing storage engine in dump file.
Aug 12
Reindl Harald Re: Changing storage engine in dump file.
Aug 12, 2015; 15:37
Reindl Harald
Re: Changing storage engine in dump file.
Aug 12
Pothanaboyina Trimurthy Re: Changing storage engine in dump file.
Aug 12, 2015; 19:09
Pothanaboyina Trimurthy
Re: Changing storage engine in dump file.
Aug 13
geetanjali mehra Re: Changing storage engine in dump file.
Aug 13, 2015; 15:10
geetanjali mehra
Re: Changing storage engine in dump file.
Aug 13
Singer Wang Re: Changing storage engine in dump file.
Aug 13, 2015; 13:01
Singer Wang
Re: Changing storage engine in dump file.
Aug 14
geetanjali mehra Re: Changing storage engine in dump file.
Aug 14, 2015; 09:18
geetanjali mehra
Re: Changing storage engine in dump file.
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!