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

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

 

Solution

Wamp

1. Edit my.ini file from c:\wamp64\bin\mysql\mysql5.7.31
2. find line and change with max_allowed_packet = 1024M
3. Restart wampserver

xamp

1. Edit my.ini file from c:\xampp\mysql\bin\my.ini
2. find line and change with max_allowed_packet = 1024M
3. Start the services and try..

That’s it