mysql - WordPress 数据库导入出现奇怪的错误

Question

我导出了Wordpress的数据库。到目前为止，一切都很好。但是当我尝试从 cPanel 通过 PHPMyAdmin 导入它时，我开始收到以下错误:

INSERT INTO wp_commentmeta VALUES (

"1", "1", "_wp_trash_meta_status", "1" );

MySQL said: Documentation

1030 - Got error -1 from storage engine

我尝试更换浏览器、主机、通过不同的模块导出数据库。没有任何效果。

我还尝试使用 cPanel 中提供的“修复”功能修复数据库，但它不起作用，因为我收到了以下回复:

[projamz1_pds.wp_commentmeta] note: The storage engine for the tabledoesn't support repair [projamz1_pds.wp_comments] note: The storageengine for the table doesn't support repair[projamz1_pds.wp_layerslider] note: The storage engine for the tabledoesn't support repair [projamz1_pds.wp_links] note: The storageengine for the table doesn't support repair [projamz1_pds.wp_options]note: The storage engine for the table doesn't support repair[projamz1_pds.wp_popover_ip_cache] note: The storage engine for thetable doesn't support repair [projamz1_pds.wp_postmeta] note: Thestorage engine for the table doesn't support repair[projamz1_pds.wp_posts] note: The storage engine for the table doesn'tsupport repair [projamz1_pds.wp_revslider_css] note: The storageengine for the table doesn't support repair[projamz1_pds.wp_revslider_layer_animations] note: The storage enginefor the table doesn't support repair[projamz1_pds.wp_revslider_settings] note: The storage engine for thetable doesn't support repair [projamz1_pds.wp_revslider_sliders] note:The storage engine for the table doesn't support repair[projamz1_pds.wp_revslider_slides] note: The storage engine for thetable doesn't support repair [projamz1_pds.wp_revslider_static_slides]note: The storage engine for the table doesn't support repair[projamz1_pds.wp_term_relationships] note: The storage engine for thetable doesn't support repair [projamz1_pds.wp_term_taxonomy] note: Thestorage engine for the table doesn't support repair[projamz1_pds.wp_terms] note: The storage engine for the table doesn'tsupport repair [projamz1_pds.wp_usermeta] note: The storage engine forthe table doesn't support repair [projamz1_pds.wp_users] note: Thestorage engine for the table doesn't support repair

我认为问题核心的代码是:

INSERT INTO wp_commentmeta (meta_id, comment_id, meta_key,meta_value) VALUES (1, 1, '_wp_trash_meta_status', '1'), (2, 1,'_wp_trash_meta_time', '1425058099'), (3, 18, '_wp_trash_meta_status','0'), (4, 18, '_wp_trash_meta_time', '1425058099'), (5, 34,'_wp_trash_meta_status', '0'), (6, 34, '_wp_trash_meta_time','1425058099'), (7, 33, '_wp_trash_meta_status', '0'), (8, 33,'_wp_trash_meta_time', '1425058099'), (9, 10, '_wp_trash_meta_status','0'), (10, 10, '_wp_trash_meta_time', '1425058099'), (11, 9,'_wp_trash_meta_status', '0'), (12, 9, '_wp_trash_meta_time','1425058099'), (13, 19, '_wp_trash_meta_status', '1'), (14, 19,'_wp_trash_meta_time', '1425058099'), (15, 23,'_wp_trash_meta_status', '1'), (16, 23, '_wp_trash_meta_time','1425058099'), (17, 22, '_wp_trash_meta_status', '1'), (18, 22,'_wp_trash_meta_time', '1425058099'), (19, 32,'_wp_trash_meta_status', '0'), (20, 32, '_wp_trash_meta_time','1425058099'), (21, 31, '_wp_trash_meta_status', '0'), (22, 31,'_wp_trash_meta_time', '1425058099'), (23, 3, '_wp_trash_meta_status','0'), (24, 3, '_wp_trash_meta_time', '1425058099'), (25, 30,'_wp_trash_meta_status', '0'), (26, 30, '_wp_trash_meta_time','1425058099'), (27, 29, '_wp_trash_meta_status', '0'), (28, 29,'_wp_trash_meta_time', '1425058099'), (29, 28,'_wp_trash_meta_status', '0'), (30, 28, '_wp_trash_meta_time','1425058099'), (31, 15, '_wp_trash_meta_status', '0'), (32, 15,'_wp_trash_meta_time', '1425058099'), (33, 27,'_wp_trash_meta_status', '0'), (34, 27, '_wp_trash_meta_time','1425058099'), (35, 26, '_wp_trash_meta_status', '0'), (36, 26,'_wp_trash_meta_time', '1425058099'), (37, 2, '_wp_trash_meta_status','0'), (38, 2, '_wp_trash_meta_time', '1425058099'), (39, 25,'_wp_trash_meta_status', '0'), (40, 25, '_wp_trash_meta_time','1425058099'), (41, 24, '_wp_trash_meta_status', '0'), (42, 24,'_wp_trash_meta_time', '1425058104'), (43, 8, '_wp_trash_meta_status','1'), (44, 8, '_wp_trash_meta_time', '1425058104'), (45, 7,'_wp_trash_meta_status', '1'), (46, 7, '_wp_trash_meta_time','1425058104'), (47, 6, '_wp_trash_meta_status', '1'), (48, 6,'_wp_trash_meta_time', '1425058104'), (49, 5, '_wp_trash_meta_status','1'), (50, 5, '_wp_trash_meta_time', '1425058104'), (51, 4,'_wp_trash_meta_status', '1'), (52, 4, '_wp_trash_meta_time','1425058104'), (53, 11, '_wp_trash_meta_status', '1'), (54, 11,'_wp_trash_meta_time', '1425058104'), (55, 14,'_wp_trash_meta_status', '1'), (56, 14, '_wp_trash_meta_time','1425058104'), (57, 13, '_wp_trash_meta_status', '1'), (58, 13,'_wp_trash_meta_time', '1425058104'), (59, 12,'_wp_trash_meta_status', '1'), (60, 12, '_wp_trash_meta_time','1425058104'), (61, 17, '_wp_trash_meta_status', '1'), (62, 17,'_wp_trash_meta_time', '1425058104'), (63, 16,'_wp_trash_meta_status', '1'), (64, 16, '_wp_trash_meta_time','1425058104');

虽然我不想删除它并像这样导入，因为我担心我会破坏一些东西。

有什么建议吗？

LE:我尝试导入但没有怀疑有问题的部分。没有成功。仍然是相同的错误 - #1030 - 来自存储引擎的错误 -1。但现在我导入了两张表，而不是一张。还是无法找出问题所在。由于 wordpress 工作正常，没有任何问题。我认为当我尝试导出数据库时会发生一些事情。

干杯

Answer 1

一些廉价且令人讨厌的共享托管提供商不支持所有 MySQL 访问方法。

试试这个:例如，对于每个表，找到由导出生成的 SQL 文件的一部分，如下所示。

CREATE TABLE `wp_options` (
    `option_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `option_name` VARCHAR(64) NOT NULL DEFAULT '',
    `option_value` LONGTEXT NOT NULL,
    `autoload` VARCHAR(20) NOT NULL DEFAULT 'yes',
    PRIMARY KEY (`option_id`),
    UNIQUE INDEX `option_name` (`option_name`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

删除 ENGINE=something 行，然后重试导入。这将允许 MySQL 服务器使用它可用的任何引擎。