MYSQL Import Error 1031

Posted on 2010-11-23
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!?
Question by:Satnav
  • 2
  • 2
LVL 16

Expert Comment

ID: 34202629
does your sql file contains following  :


Author Comment

ID: 34202642
yes it does.


Open in new window

LVL 16

Accepted Solution

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

It happened with me ages ago.

here is the link :

Author Closing Comment

ID: 34202673
Removed Every instance of DELAYED IGNORE

Imported Sucessfully

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MySql Database Installation 5 76
Get AVG of SUM in MySQL with other SUMS 5 43
mySql Syntax 7 33
simple mysql statement 3 11
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…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

24 Experts available now in Live!

Get 1:1 Help Now