how to extend limit of import file in phpmyadmin

December 28, 2014 24.7k views

hello, I'm using ubuntu 12.04 , i have setup mysql, phpadmin all, when i was ready to import my sql back up and it'z size around 105mb, but the current limit is (Max: 2,048KiB) in import. it is very low , so can any one please explain me how to extend this limit.

Thank's in advance.

P.S share proper steps or refer link of tutorial.

  • @kamaln7 you here?
    Please help me out.

  • you need to three changes in php.ini file.
    nano /etc/php5/apache2/php.ini
    e.g: memory
    limit 128M
    postmaxsize 12M
    uploadmaxfilesize 10M
    Don't forget to restart apache service.

3 Answers

Edit /etc/php5/apache2/php.ini, set upload_max_filesize and post_max_size to 150M and restart Apache:

sudo service apache2 restart

You should then be able to upload your SQL dump using phpMyAdmin.

Once you've done that, it's safer to lower the size limit back to a reasonable value like 8M or so. Don't forget to restart Apache after editing php.ini.

After Several hours trying to figure out why changes to php.ini doesn't work on max upload size, i decided to take other here goes the....

Ways of making work changes to uploadmaxfilesize, or php.ini max upload size doesn't work:

FIRST remember to also increase postmaxsize just in case is that the limit as that one overrides uploadmaxfilesize...

Here goes the ways to make work uploadmaxfilesize without touching PHP.ini!!!!

Add next content to .htaccess file at your app or site directory:

<IfModule mod_php5.c>
phpvalue uploadmaxfilesize 40M
value postmaxsize 40M


Add this to the conf file of the site or application (usually at /etc/nginx/sites-available)

location ~ .php$ {
fastcgiparam PHPVALUE "uploadmaxfilesize = 50M \n postmaxsize=51M";


CREATE A FILE user.ini (where user is the user that have access to that folder, usually files are owned by this user) put this file on the directory where the php is located, user.ini must have next content:

uploadmaxfilesize = 40M

postmaxsize = 40M


Inside the php that must upload the file or files at the top inside php brackets of course, put:

iniset('postmaxsize', '64M');
set('uploadmaxfilesize', '64M');

One of this solutions must work, in my case was the Apache one, and worked perfect, try yours!!!

I tried all mentioned above. But it is not working :(
My current php version is PHP6 where file import in db is not working.
My my initial php version, it is working absolutely fine - PHP 5
please suggest

Have another answer? Share your knowledge.