InnoDB is, in theory, always going to be a better storage engine. Offering database features that should be part and parcel of all applications. On the internet, speed is king. Faster pages are always better. So, unless you know differently, leave things as they are. Your host controls your database version. Your database developers have tuned and selected the fastest engine. Go with that.
It did not show any error message or the database can not be used, when i upgrade Wordpress before, but when i would like to change the content of my.cnf to optimize the mysql, it seems that has become very difficult. Why do I have to say so? That is because i can access and enable mysql after I changed my.cnf file...
"Exports your database, does a find and replace on URLs and file paths, then allows you to save it to your computer.
WP Migrate DB exports your database as a MySQL data dump (much like phpMyAdmin), does a find and replace on URLs and file paths, then allows you to save it to your computer. It is perfect for developers who need to update their local install with fresh data from the production site, or copy their locally developed site to a staging or production server.
It even takes into account serialized data (both arrays and objects) and updates the string length values."
"WP Migrate DB exports your database as a MySQL data dump (much like phpMyAdmin), does a find and replace on URLs and file paths, then allows you to save it to your computer. It is perfect for developers who develop locally and need to move their WordPress site to a staging or production server."