• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

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?
1 Solution
   Instead of importing the data from existing server to testing environment.
Take a backup and restore it in the testing server.
Use the following commands to backup and restore the database.

#mysqldump database_name > database_name.sql
#mysql database_name < database_name.sql
techbotsAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now