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 awayEdit 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.
