Re: Changing storage engine in dump file.

2015-08-13 Thread geetanjali mehra
I have already made this attempt. And really I stucked into some problems. I found lots of full text indexes created on the data directory . I don't know from where they come. We have never created full text indexes for that database. Slave also was not able to sync with its master. Now, I have res

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 wrote: > > - Original Message - > > From: "geetanjali mehra" > > Subject: Changing storage engine in dump file. > > > > Is there any implic

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 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 a mix >> of innodb