import_large_sql_file.md

Enable large sql file import in xampp

i) Open file C:\xampp\php

ii) Search for the following 3 properties and set there value according to your need

memory_limit
post_max_size
upload_max_filesize

iii) Restart Apache!

For linux (nginx)

i) Open file /etc/php/7.1/fpm/php.ini

Search for the following 3 properties and set there value according to your need

memory_limit
post_max_size
upload_max_filesize

ii) Allow large upload in nginx configuration Open nginx.conf sudo nano /etc/nginx/nginx.conf

Inside http {}, put

http {
      client_max_body_size 20M;         
}

iii) Restart nginx and php!

sudo service nginx restart
sudo service php7.1-fpm restart