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
Step 2: Select Format Specific Options as listed below
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.