In the mysql backup file, did you have entries like sql_mode = ...., NO_AUTO_CREATE_USER, ... ?
sql_mode = ...., NO_AUTO_CREATE_USER, ...
I've dumped the DB contents with the workbench and on import it was more obvious that the errors were with the CiviCRM tables inside the schema.
I'll take it to the CiviCRM stackexchange.
One more question -- is there a Multisite Wordpress AWS AMI with the newer PHP but mysql 5.x still? How can I locate and launch said AMI?
Good to know that the issue was solved! As far as I know we don't have an AMI with these requirements.
If you find other issues, do not hesitate to open a new thread.
Javier J. Salmeron