asked on

mySQL 1064 error during WordPress phpmyadmin import

I am trying to copy a Wordpress install from one server to a test environment and I am getting the following error when I try to import the database in phpmyadmin:

#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 '\r\n@font-face\r\n {font-family:Times;\r\n panose-1:2 0 5 0 0 0 0 0 0 0;\r\n mso' at line 13274

I don't have a clue what the problem is or how to fix it. It looks like there is a lot of MSWord formatting in the posts - but there are 1700 posts so not something I can fix manually. Any ideas on how to make this work?

ASKER CERTIFIED SOLUTION

Naranthiran D

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

techbots

ASKER

After a few misfires, I was able to get the Export/Import function in WordPress to transfer the bulk of the content to the test environment. Not sure this solves my problem for when I need to transfer the site back to the live server, but for now it got me where I need to be.

I couldn't use the backup function because I don't have access to phpmyadmin on the live server. I had to use Backup to WordPress plugin to get the full sql dump, but that was where I was getting the sql errors.

But your tip got me pointed in the right direction so I will award you the points.