Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MYSQL Import Error 1031

Posted on 2010-11-23
4
Medium Priority
?
1,185 Views
Last Modified: 2012-05-10
I have exported the database from phpmyadmin on a Windows Server running Plesk Windows 9.2
and I am trying to import it onto a linux server running cPanel WHM 11.28.45.

When trying to import using phpmyadmin the following error appears:

MySQL said: Documentation
#1031 - Table storage engine for 'xxxxxxx' doesn't have this option


When trying to import using SSH the following error appears:
ERROR 1031 (HY000) at line 205: Table storage engine for 'xxxxxxx' doesn't have this option


Anybody else had this problem?? or know of any solutions!?
0
Comment
Question by:Satnav
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:santoshmotwani
ID: 34202629
does your sql file contains following  :

"INSERT DELAYED IGNORE INTO" ???
0
 

Author Comment

by:Satnav
ID: 34202642
yes it does.

INSERT DELAYED IGNORE INTO

Open in new window

0
 
LVL 16

Accepted Solution

by:
santoshmotwani earned 2000 total points
ID: 34202649
Please remove DELAYED IGNORE and it will work fine.

It happened with me ages ago.

here is the link :
http://mysql.bigresource.com/Track/mysql-Ai45l34F/
0
 

Author Closing Comment

by:Satnav
ID: 34202673
Removed Every instance of DELAYED IGNORE

Imported Sucessfully
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 5 hours left to enroll

927 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