Solved

MYSQL Import Error 1031

Posted on 2010-11-23
4
1,083 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 500 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

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

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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