I’m receiving the following error when attempting to migrate a multisite from my local system to the remote server:
Error: The database backup uses MySQL features not available in the old MySQL version (5.1.66) that this site is running on. You must upgrade MySQL to be able to use this database.
I am aware that I am running a more recent version of mySQL and this is causing a problem with incompatibility of the collation methods. In non-multisite versions I’ve been able to fix this simply by exporting the database, running a search and replace on the sql file to
1. Find utf8mb4_unicode_520_ci
2. Replace with utf8mb4_general_ci
however this method does not seem to be working with multisite. Any suggestions? (I mean other than reinstalling my wampserver with an older version of mysql).