How To Increase import file size in PHPMyAdmin

By default when you want to import sql file size is 2MB in PHPMyAdmin.
That is PHP’s file upload limit.

To change maximum import file size do following step:

     1.Find php.ini file:  Type locate php.ini this command to find php.ini file.

 

     2.Edit php.ini file: Type sudo gedit /etc/php/7.0/apache2/php.in  this command to edit php.ini file.

 

    3. Find following variables and change values as you need: Type this command to change values as you need.

   post_max_size = 200M
   upload_max_filesize = 200M
   max_execution_time = 200
   max_input_time = 200
   memory_limit = 200M

   4. Restart apache to take effect:

Type sudo service apache2 restart this command for restart apache server.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.