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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (  Today ( you would not use MySQL…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

630 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