Customer Support

The error 1064 occurs due to Mysql version mismatch,because differnt
versions have differnt 
reserved words,which if used by a previous version causes the error to
occur.

The simplest and most effective solution for it is.
-when using phpMyadmin,select the "compatibility mode" & select the
target db version from the drop down box.
-when using MySql administrator,while backing up  choose  "compatibility
mode" in adavanced tab ,
and while restoring through mysql administrator ,click  "auto-detect
file charater set" if backup was not made using mySql administrator.
the default file characer set used by mysql admministrator is utf8.

Taking these precautions, generally should get the things working for
you.
however there maybe some exceptions to this solution.
In that case you will have to see the error it is giving .
say for eg, in my case error was 
-------------------------------------------------
Error Code : 1064 You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'DEFAULT CHARSET=latin1
-------------------------------------------------
Here i could replace latin1 with utf8,
because my target version of mysql was different from the from which i
took backup.
-------------------------------------------------
In case of other serious errors you may 
search mysql forums

Adios,
Nitin Kaul