Solved

mySQL 1064 error during WordPress phpmyadmin import

Posted on 2014-02-02
2
823 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

895 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

13 Experts available now in Live!

Get 1:1 Help Now