Fixing Error #1064 issues when exporting mysql database

You might have faced an issue when exporting mysql database from server to localhost/phpmyadmin.

One of the reason for this issues is the compatibility between the versions of PHP and MYSQL used at both ends.

Fortunately this can be fixed in 2 easy steps when exporting database from server to localhost environment.

Step 1: Select Custom Export Method

Fixing Error #1064 issues when exporting mysql database

Step 2: Select Format Specific Options as listed below

Fixing Error #1064 issues when exporting mysql database

About Author

I am Robin - WordPress Developer based in Sydney. I work as Digital Developer. I do some projects now and then, and love blogging about WordPress and Web Design.