Solved. Exported database to .sql file, changed 'ENGINE=InnoDB' to 'ENGINE=MyISAM', created new database, added existing database user with full priviledges and populated new database by importing .sql file. Finally changed configuration.php for new database name. The site appears to be running. Deleted old database. Thanks. Regards.