WordPress MySql incompatibility. Locally developed version : 5.6.17 & hosting providers version 5.5.36

Question

I developed a wordpress site locally using WAMP with MySQL ver. 5.6.17. While trying to take the website live (using the Duplicator wp plugin), I am not able to as I got an error for version incompatibility.

The shared hosting that i have purchased to take the site live cant upgrade the MySql version from 5.5.36 to 5.6.n.

Is there something I can do now with the wp site locally developed to take it live? looking for any possible solutions...

Answer 1

Duplicator has a mode where it uses mysqldump to write out your database contents when preparing the package for duplication. That mode is enabled on Duplicator's settings page. If you write your package with that tool you may, or may not, be able to persuade your cheap and nasty hosting service to import it.