noone-special ۰

Importing and exporting mySQL dumps for most of the time is quick and easy even for both phpMYadmin and SSH. Unexpected errors do occur, considerably, if you are transferring your data between WebHosts and their different mySQL versions.

One of these is the Error #1064 which occurs due to a mismatch between the mySQL versions and it’s corresponding reserved words, which if used causes the error 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 advanced 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.

If you have questions, please feel free to ask - I would love to help you out.