Unrecognized keyword (near “ON” at position 25) while importing a large data for WordPress

Your support helps keep this blog running! Secure payments via Paypal and Stripe.

Today I am working on my client’s website. The data is huge since the website is about the tours package. I want to clone the site to my localhost so I can audit the site.

How to export and import database to your localhost

• Export the data(a sql file) via phpmyadmin from the server
• Import the data(a sql file) via phpmyadmin at my localhost

While I am importing the sql file(~124MB), I receive the error below.

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

Edit the php.ini and my.ini

• At php.ini, change the value as below.

max_execution_time = 600
max_input_time = 600
memory_limit = 1024M
post_max_size = 1024M

• At my.ini, change the value as below.

max_allowed_packet = 1024M

• Restart your web server

Php.ini is for PHP. You can find this file in your PHP folder such as “C:\xampp\php\php.ini“. It depends on what web server you use.

My.ini is for MySQL. You can find this file in your MySQL folder such as “C:\xampp\mysql\bin\my.ini“. It depends on what web server you use.

Recommend tool for import the large SQL file into your database

I normally use MySQL Workbench. It is easy to use. You can use a remote database as well.

That’s it for today. Hope it is helpful.

Your support helps keep this blog running! Secure payments via Paypal and Stripe.