How to import big sql file into PHPmyadmin

How to import big or large sql file into PHPmyadmin

  • If you have APACHE SERVER

Step 1. – First find the php.ini file

Step 2. – Your php.ini file in like this path “C:\wamp64\bin\php\php7.0.10”

Step 3. – Open the php.ini file in notepad or suitable text editor

step 4. – Now find these all and replace with below code

post_max_size=500M

upload_max_filesize=500M

memory_limit=900M

max_execution_time = 1000

Restart the apache server now.

  • If you have NGINX SERVER

Please find the file at this path

/etc/nginx/nginx.conf ib the http{…..} block

and add this.

client_max_body_size 912M;

 

Leave a Reply

Your email address will not be published. Required fields are marked *