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 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, is that the maximum key lenght for > MyISAM is 1000 bytes, but for InnoDB it is only 786 bytes... > > Depending on your server version, InnoDB may not yet have fulltext > indices, and even if it does, the behaviour is different from the MyISAM > ones. > > You are likely to run into a myriad of tiny little differences, and it > seems to me like a fairly bad plan. Why do you want this? > > > -- > Unhappiness is discouraged and will be corrected with kitten pictures. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
