change whole database engine code example Example: alter table engine mysql ALTER TABLE table_name ENGINE=InnoDB;