Archive December 2018

Alter the Upload/Import Size limit in phpMyAdmin

Alter the Upload/Import Size limit in phpMyAdmin

NOTE: This is a post for people who are using phpMyAdmin and having this limit. If you are not having phpMyAdmin or you have already set the limit, this post is not for you and you should spend your valuable time in something else. You can ofcourse know about phpMyadmin here: //www.phpmyadmin.net

Many of us know about the great tool phpMyAdmin which is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

In some servers, this tool may have limits and some limits can be altered if you have all the privileges. One of the limits most commonly set is the import limit that is 2,048kb which is 2mb.

Here we are going to talk about how to exceed that limit.

If you are running WAMP as how im running, you should then easily be able to do this, follow me user!

  • First steps first, make sure you have the php.ini file located on the folder you installed php onto.
  • Now Edit/Open php.ini file in any text editor. Now note down these terms somewhere:

upload_max_filesize

post_max_size

max_execution_time

max_input_time

memory_limit

  • Now search for these terms one by one, firstly, ‘upload_max_filesize’ should be set to your desired limit such as ‘1024M’.
  • Second, ‘post_max_size’ should be equal to ‘upload_max_filesize’ that is if you had set ‘upload_max_filesize’ to ‘1024M’ then you should also set the ‘post_max_size’ to ‘1024M’
  • Third, ‘max_input_time’ can be set to something high for example ‘3600’ and same as the above one, max_input_time should be equal to max_execution_time.
  • Fourth, memory_limit should be equal to upload_max_filesize.
  • Save php.ini

So that all is done, try restarting your server, if it didn’t work, don’t worry, there’s a extended step too.

NOTE: Don’t revert back any of the changes of php.ini

Find the phpmyadmin.conf file on your computer and edit it in a text editor and do the following steps. For WAMP it is located at C:\wamp\alias\phpmyadmin.conf

  • After opening it in a text editor, if you see these codes, for example:

php_admin_value upload_max_filesize somethingM
php_admin_value post_max_size somethingM
php_admin_value max_execution_time something
php_admin_value max_input_time something

NOTE: I denoted ‘something’ for the values, the values maybe different for different users.

NOTE: If you don’t find these codes in the file like it happened for me, copy these codes and paste it in the file.

Change these values as you changed it in the php.ini file, for example:

php_admin_value upload_max_filesize 1024M
php_admin_value post_max_size 1024M
php_admin_value max_execution_time 3600
php_admin_value max_input_time 3600

  • Save the phpmyadmin.conf file.

Restart the server again, this time it should have worked and if not, then sorry we are not responsible for anything and we have no other solution.

Contact us if you have any doubts on this post.

-Written by Yet Zio

www.000webhost.com