How are you attempting transfer ... with the 'experimental tool' in Moodle? or are you taking a mysqldump of the local DB and importing that dump into a DB on the server?
Is the DB server to which you are transferring set for InnoDB ... in particular this setting:
Caution there are other InnoDB settings that should be in DB server config so adding just the one line might produce other errors.
'spirit of sharing', Ken