This is the sql script created by sqlyog for the left side:
/* Alter table in Second database */ <- right
alter table `galassia`.`tblsoci`, type=MyISAM; <- wrong
and this is the one for the right side:
/* Alter table in First database */ <- right
alter table `galassia`.`tblsoci`, type=InnoDB; <- wrong
The scripts should be:
/* Alter table in Second database */
alter table `galassia`.`tblsoci`, type=InnoDB;
/* Alter table in First database */
alter table `galassia`.`tblsoci`, type=MyISAM;
The trouble seems to be that only the table type is to be modified. I tried to change a property of a column in the same table and the script was right. Hope this helps.
Regards.
Krypta.