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

Save
3 years ago
1

How to fix: Error (near "ON" at position 25) while importing Table for WORDPRESS ( A foreign key Error)
If you face 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

You need to increase memory limit.
Changing php.ini at C:\xampp\php\php.ini
max_execution_time = 600
max_input_time = 600
memory_limit = 1024M
post_max_size = 1024M
Changing my.ini at C:\xampp\mysql\bin\my.ini

max_allowed_packet = 1024M

Loading comments...