Re: Changing storage engine in dump file.

2015-08-13 Thread geetanjali mehra
Thanks everyone for their reply. Best Regards, Geetanjali Mehra Senior Database Administrator On Wed, Aug 12, 2015 at 7:07 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 12.08.2015 um 15:07 schrieb geetanjali mehra: I am in the process of creating a new slave. On my master, there is

Re: Changing storage engine in dump file.

2015-08-13 Thread Singer Wang
Depending on the version of MySQL and InnoDB engine, the max key length can be 3072 for InnoDB.. On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Changing storage engine

Re: Changing storage engine in dump file.

2015-08-13 Thread geetanjali mehra
.. On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Changing storage engine in dump file. Is there any implications in doing so. Is this approach correct? Will I face

Changing storage engine in dump file.

2015-08-12 Thread geetanjali mehra
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

Re: Changing storage engine in dump file.

2015-08-12 Thread Johan De Meersman
- Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Changing storage engine in dump file. Is there any implications in doing so. Is this approach correct? Will I face any problem in syncing the slave? The first thing that occurs to me

Re: Changing storage engine in dump file.

2015-08-12 Thread Pothanaboyina Trimurthy
vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Changing storage engine in dump file. Is there any implications in doing so. Is this approach correct? Will I face any problem in syncing the slave? The first thing

Re: Changing storage engine in dump file.

2015-08-12 Thread Reindl Harald
Am 12.08.2015 um 15:07 schrieb geetanjali mehra: 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