Friday, September 23, 2016

Migrate MyISAM tables to INNODB using mysqldump

In this article you will find information how to convert MyISAM tables to INNODB.  The procedure here is an offline procedure, i.e, you cannot have changes on the SOURCE database, while you do this. A better way could be to setup replication between the SOURCE and the TARGET, but that is not described here. On the source database In this example we dump out the database...