Solved

mySQL 1064 error during WordPress phpmyadmin import

Posted on 2014-02-02
2
808 Views
Last Modified: 2014-02-03
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?
0
Comment
Question by:techbots
2 Comments
 
LVL 5

Accepted Solution

by:
NARANTHIRAN earned 500 total points
Comment Utility
Hi,
   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.

Backup
#mysqldump database_name > database_name.sql
Restore
#mysql database_name < database_name.sql
0
 
LVL 1

Author Comment

by:techbots
Comment Utility
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.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now