我尝试将一个大文件导入到我的数据库(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"附近)(外键错误)
发布评论