导入WORDPRESS的表格时出现错误(位置25附近为"ON"附近)(外键错误) [英] Error (near "ON" at position 25) while importing Table for WORDPRESS ( A foreign key Error)

问题描述

我尝试将一个大文件导入到我的数据库(WordPress)，它显示出如下错误:

I try to import a large file to my Database (WordPress), it shows some error like this:

Error

Static analysis:

1 errors were found during analysis.

    Unrecognized keyword. (near "ON" at position 25)

SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation
#2006 - MySQL server has gone away

推荐答案

当我尝试将Drupal数据库迁移到新的本地apache服务器时，我遇到了相同的错误(我在Windows计算机上使用XAMPP).实际上，我不知道此错误的含义，但是在尝试了以下步骤之后，我没有错误地导入了数据库.希望这会有所帮助:

I had the same error when I tried to migrate Drupal database to a new local apache server(I am using XAMPP on Windows machine). Actually I don't know the meaning of this error, but after trying steps below, I imported the database without errors. Hope this could help:

在C:\ xampp \ php \ php.ini中更改php.ini

Changing php.ini at C:\xampp\php\php.ini

max_execution_time = 600
max_input_time = 600
memory_limit = 1024M
post_max_size = 1024M

将my.ini更改为C:\ xampp \ mysql \ bin \ my.ini

Changing my.ini at C:\xampp\mysql\bin\my.ini

max_allowed_packet = 1024M

这篇关于导入WORDPRESS的表格时出现错误(位置25附近为"ON"附近)(外键错误)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！