Solved

mySQL 1064 error during WordPress phpmyadmin import

Posted on 2014-02-02
2
830 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
ID: 39828819
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
ID: 39830176
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

773 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