The error 1064 occurs due to MySQL version mismatch. Different versions have different reserved words, which, if they are used by a previous version, causes the error to occur.
The simplest and most effective solution for it is the following: when using phpMyadmin (accessible from your Control Panel), select the "compatibility mode" & select the target database version from the drop down box. That's it! You shouldn't get the same error again.