Skip to content

Instantly share code, notes, and snippets.

@debojyoti
Last active October 14, 2018 12:45
Show Gist options
  • Save debojyoti/0885d677322503e5139bd2b58bbc4cc5 to your computer and use it in GitHub Desktop.
Save debojyoti/0885d677322503e5139bd2b58bbc4cc5 to your computer and use it in GitHub Desktop.

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment