导入WORDPRESS的表格时出现错误(位置25附近为"ON"附近)(外键错误)

本文介绍了导入WORDPRESS的表格时出现错误(位置25附近为"ON"附近)(外键错误)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我尝试将一个大文件导入到我的数据库(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