Error (near “ON” at position 25) while importing Table for WORDPRESS

SET FOREIGN_KEY_CHECKS = ON
Some time When we import the large database file then shows the errors like as below:

Error
Static analysis:
1 errors were found during analysis.

    Missing expression. (near "ON" at position 25)

SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

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

The solution of this problem is to change the php.ini values as below:

max_execution_time = 500
max_input_time = 500
memory_limit = 512M
post_max_size = 512M
max_allowed_packet = 512M

Now restart the services… hope it will work.

Leave a Reply