[Solved] MySQL #1064 Error in WordPress Migration

 

If You Have a Following Error:

 

#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 ‘<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w’at line


 

I Have A Solution:

 

Solution 1:

1).Go To PhpMyadmin

2).Find Database To Export

3).In Export Method, select Custom.

4)In Compression Located in Output Section Select gzipped

5)Save sql file and Export And Enjoy

 

Leave a comment