I have not yet found the reason why the plugin did not work to begin with.
The SQL I sent you was exported from my machine. Most of the collation and charset directives are not needed. Only the ones that refer to the latin1 charset. You should be OK with MySQL 5.5. I have edited the SQL code and removed any unnecessary charsets. Your system should now use whatever is default for the columns where it doesn’t matter.
So please do another attempt. Use the same pastebin link. I have edited it.