Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1206
  • Last Modified:

MYSQL Import Error 1031

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
Satnav
Asked:
Satnav
  • 2
  • 2
1 Solution
 
santoshmotwaniCommented:
does your sql file contains following  :

"INSERT DELAYED IGNORE INTO" ???
0
 
SatnavAuthor Commented:
yes it does.

INSERT DELAYED IGNORE INTO

Open in new window

0
 
santoshmotwaniCommented:
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
 
SatnavAuthor Commented:
Removed Every instance of DELAYED IGNORE

Imported Sucessfully
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now