first of all find out the version of mysql running on your old host versus your new host.
Im pretty sure you are probably trying to put a new version of mysql coding into an older mysql system .
you can try opening up your sql file in word pad and do a search on SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”; and replace with a space to try to remove all that code in one shot, and do this for all errors you encounter. or you can just request to your host what version of mysql you will be needing, but if this is a shared host account you will prolly not get any help with that.
try what i said .. remove the code that is giving you errors
