Как изменить максимальный размер phpmyadmin

Does anyone know if or how you can increase the import size limit in phpMyAdmin? Currently my server is limited to 50MB.

Please note that this is not the same as the upload_max_filesize in php.ini. That value is set to 2MB.

I need to import a table into one of my DBs and the phpMyAdmin restriction of 50MB on the import is preventing me from doing that.

Thanks.

Amended — attached are 2 screen shots:

Screen Shot #1 — phpinfo() showing the php.ini settings.

Screen Shot #2 — showing the phpMyAdmin import restriction

asked Oct 3, 2012 at 11:45

Change these values in php.ini

post_max_size = 750M 
upload_max_filesize = 750M 
max_execution_time = 5000 
max_input_time = 5000 
memory_limit = 1000M 

Then restart Wamp for the changes to take effect. It will take some time. If you get following error:

Script timeout passed if you want to finish import please resubmit same zip file and import will resume.

Then update the phpMyAdmin configuration, at phpMyAdminlibrariesconfig.default.php

/**
 * maximum execution time in seconds (0 for no limit)
 *
 * @global integer $cfg['ExecTimeLimit']
 */
$cfg['ExecTimeLimit'] = 0;

answered Jul 7, 2015 at 10:53

First you have to change values in php.ini file as per your requirements.

post_max_size = 1024M 
upload_max_filesize = 1024M 
max_execution_time = 3600
max_input_time = 3600 
memory_limit = 1024M 

Note — Change these values carefully. These values will impact for all of your projects of that server.

Now, If above solutions are not working, kindly check your phpmyadmin.conf file.
If you are using WAMP so you can find the file in «C:wamp64alias».

You have to change below values.

Values already in file are —

  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360

Change above code to —

#  php_admin_value upload_max_filesize 128M
#  php_admin_value post_max_size 128M
#  php_admin_value max_execution_time 360
#  php_admin_value max_input_time 360

Now just restart your server, to work with changed values.

answered Feb 24, 2017 at 10:26

Change the file phpmyadmin.conf on c:/wamp64/alias/phpmyadmin.conf

php_admin_value upload_max_filesize 512M
php_admin_value post_max_size 512M
php_admin_value max_execution_time 360
php_admin_value max_input_time 360

It’s very important you increase the time to 5000 or higher, Thus, the process will not stop when you are uploading a large file.

That works for me.

answered Mar 13, 2017 at 22:22

go to your cpanel and search «ini editor». You’ll get «Multiphp INI Editor»
There you select your wordpress directory and put
upload_max_filesize = 256M
post_max_size = 256M
memory_limit = 256M

answered Sep 4, 2018 at 6:13

Be sure you are editing php.ini not php-development.ini or php-production.ini, php.ini file type is Configuration setting and when you edit it in editor it show .ini extension. You can find php.ini here: xampp/php/php

Then

upload_max_filesize = 128M
post_max_size = 128M
max_execution_time = 900
max_input_time = 50000000
memory_limit = 256M

answered Mar 29, 2019 at 16:21

1:nano /etc/php5/apache2/php.ini
you can find your php.ini location by uploading a file called phpinfo.php with the following contents<?php phpinfo();?> and access it by visiting yourdomain.com/phpinfo.php ,you will see the results

2:change the desired value to upload_max_filesize and post_max_size
such as :
upload_max_filesize = 200M
post_max_size = 300M
then it will become 200M.

3:restart your apache

answered Dec 30, 2016 at 12:00

IF YOU ARE USING NGINX :

1. cd /etc/php/<PHP_VERSION>/fpm example => cd /etc/php/7.2/fpm

2. nano php.ini

   post_max_size = 1024M 
   upload_max_filesize = 1024M 
   max_execution_time = 3600 
   max_input_time = 3600 
   memory_limit = 1024M 
   

3. after saving php.ini file , restart fpm using :

   systemctl restart php<PHP_VERSION>-fpm
   

example => systemctl restart php7.2-fpm

answered Nov 30, 2020 at 7:05

answered May 18, 2015 at 8:39

You Can Search php.ini file in C:xampphtdocs

changes into the php.ini file

post_max_size = 805M 
upload_max_filesize = 805M 
max_execution_time = 5005 
max_input_time = 5005 
memory_limit = 1005M 

After editing Please restart XAMPP

answered Oct 19, 2016 at 6:35

On newer version of cpanel: search ini

size’ and edit it…then save[enter

answered May 16, 2017 at 13:32

Sharky’s answer was spot on. The phpMyAdmin upload file size displayed is NOT managed by the php.ini settings, which you can see when you run a phpinfo.php containing:

<?php
// Show all information, defaults to INFO_ALL
phpinfo();
?>

It is good practice to increase your php.ini settings for:

post_max_size
upload_max_filesize
max_execution_time
max_input_time
memory_limit

You may use the settings example that Sujiraj R shared. Once you have made all of the changes to both your php.ini AND in the»Tweak Settings» area of WHM, when you launch phpMyAdmin and go to the import screen, you will see the size you selected for «cPanel PHP max upload size» field.

There were a lot of good answers on this post, but you had to look back and forth to get the right answer. I hope that by encapsulating those previous answers in this post I have helped just a bit. All of the answers I refer to on this post were derived by others that posted here, so please do not credit me with any of the answers posted herein.

answered Oct 9, 2017 at 19:04

If you don’t want to change the upload size limit, or for some reason can not change the upload size limit, compressing the database to a zip or tar.bz2 will really reduce the size of your database. In my case it went from 60MB which was >10MB over the limit, and compressed to a zip it was only 18MB!

Does anyone know if or how you can increase the import size limit in phpMyAdmin? Currently my server is limited to 50MB.

Please note that this is not the same as the upload_max_filesize in php.ini. That value is set to 2MB.

I need to import a table into one of my DBs and the phpMyAdmin restriction of 50MB on the import is preventing me from doing that.

Thanks.

Amended — attached are 2 screen shots:

Screen Shot #1 — phpinfo() showing the php.ini settings.

Screen Shot #2 — showing the phpMyAdmin import restriction

asked Oct 3, 2012 at 11:45

Change these values in php.ini

post_max_size = 750M 
upload_max_filesize = 750M 
max_execution_time = 5000 
max_input_time = 5000 
memory_limit = 1000M 

Then restart Wamp for the changes to take effect. It will take some time. If you get following error:

Script timeout passed if you want to finish import please resubmit same zip file and import will resume.

Then update the phpMyAdmin configuration, at phpMyAdminlibrariesconfig.default.php

/**
 * maximum execution time in seconds (0 for no limit)
 *
 * @global integer $cfg['ExecTimeLimit']
 */
$cfg['ExecTimeLimit'] = 0;

answered Jul 7, 2015 at 10:53

First you have to change values in php.ini file as per your requirements.

post_max_size = 1024M 
upload_max_filesize = 1024M 
max_execution_time = 3600
max_input_time = 3600 
memory_limit = 1024M 

Note — Change these values carefully. These values will impact for all of your projects of that server.

Now, If above solutions are not working, kindly check your phpmyadmin.conf file.
If you are using WAMP so you can find the file in «C:wamp64alias».

You have to change below values.

Values already in file are —

  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360

Change above code to —

#  php_admin_value upload_max_filesize 128M
#  php_admin_value post_max_size 128M
#  php_admin_value max_execution_time 360
#  php_admin_value max_input_time 360

Now just restart your server, to work with changed values.

answered Feb 24, 2017 at 10:26

Change the file phpmyadmin.conf on c:/wamp64/alias/phpmyadmin.conf

php_admin_value upload_max_filesize 512M
php_admin_value post_max_size 512M
php_admin_value max_execution_time 360
php_admin_value max_input_time 360

It’s very important you increase the time to 5000 or higher, Thus, the process will not stop when you are uploading a large file.

That works for me.

answered Mar 13, 2017 at 22:22

go to your cpanel and search «ini editor». You’ll get «Multiphp INI Editor»
There you select your wordpress directory and put
upload_max_filesize = 256M
post_max_size = 256M
memory_limit = 256M

answered Sep 4, 2018 at 6:13

Be sure you are editing php.ini not php-development.ini or php-production.ini, php.ini file type is Configuration setting and when you edit it in editor it show .ini extension. You can find php.ini here: xampp/php/php

Then

upload_max_filesize = 128M
post_max_size = 128M
max_execution_time = 900
max_input_time = 50000000
memory_limit = 256M

answered Mar 29, 2019 at 16:21

1:nano /etc/php5/apache2/php.ini
you can find your php.ini location by uploading a file called phpinfo.php with the following contents<?php phpinfo();?> and access it by visiting yourdomain.com/phpinfo.php ,you will see the results

2:change the desired value to upload_max_filesize and post_max_size
such as :
upload_max_filesize = 200M
post_max_size = 300M
then it will become 200M.

3:restart your apache

answered Dec 30, 2016 at 12:00

IF YOU ARE USING NGINX :

1. cd /etc/php/<PHP_VERSION>/fpm example => cd /etc/php/7.2/fpm

2. nano php.ini

   post_max_size = 1024M 
   upload_max_filesize = 1024M 
   max_execution_time = 3600 
   max_input_time = 3600 
   memory_limit = 1024M 
   

3. after saving php.ini file , restart fpm using :

   systemctl restart php<PHP_VERSION>-fpm
   

example => systemctl restart php7.2-fpm

answered Nov 30, 2020 at 7:05

answered May 18, 2015 at 8:39

You Can Search php.ini file in C:xampphtdocs

changes into the php.ini file

post_max_size = 805M 
upload_max_filesize = 805M 
max_execution_time = 5005 
max_input_time = 5005 
memory_limit = 1005M 

After editing Please restart XAMPP

answered Oct 19, 2016 at 6:35

On newer version of cpanel: search ini

size’ and edit it…then save[enter

answered May 16, 2017 at 13:32

Sharky’s answer was spot on. The phpMyAdmin upload file size displayed is NOT managed by the php.ini settings, which you can see when you run a phpinfo.php containing:

<?php
// Show all information, defaults to INFO_ALL
phpinfo();
?>

It is good practice to increase your php.ini settings for:

post_max_size
upload_max_filesize
max_execution_time
max_input_time
memory_limit

You may use the settings example that Sujiraj R shared. Once you have made all of the changes to both your php.ini AND in the»Tweak Settings» area of WHM, when you launch phpMyAdmin and go to the import screen, you will see the size you selected for «cPanel PHP max upload size» field.

There were a lot of good answers on this post, but you had to look back and forth to get the right answer. I hope that by encapsulating those previous answers in this post I have helped just a bit. All of the answers I refer to on this post were derived by others that posted here, so please do not credit me with any of the answers posted herein.

answered Oct 9, 2017 at 19:04

If you don’t want to change the upload size limit, or for some reason can not change the upload size limit, compressing the database to a zip or tar.bz2 will really reduce the size of your database. In my case it went from 60MB which was >10MB over the limit, and compressed to a zip it was only 18MB!

Find the file called: php.ini on your server and follow below steps

With apache2 and php5 installed you need to make three changes in the php.ini file. First open the file for editing, e.g.:

sudo gedit /etc/php5/apache2/php.ini

OR

sudo gedit /etc/php/7.0/apache2/php.ini

Next, search for the post_max_size entry, and enter a larger number than the size of your database (15M in this case), for example:

post_max_size = 25M

Next edit the entry for memory_limit and give it a larger value than the one given to post_max_size.

Then ensure the value of upload_max_filesize is smaller than post_max_size.

The order from biggest to smallest should be:

    memory_limit
    post_max_size
    upload_max_filesize

After saving the file, restart apache (e.g. sudo /etc/init.d/apache2 restart) and you are set.

Don’t forget to Restart Apache Services for changes to be applied.

You probably didn’t restart your server

Or you modified the wrong php.ini.

Or you actually managed to do both ^^

answered Oct 18, 2010 at 11:29

Just change your php.ini(xampp/php/php.ini) file, it worked for me!

max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M
post_max_size = 750M
upload_max_filesize = 750M

And, don’t forget to restart Apache Module from XAMPP Control Panel.

answered Apr 5, 2015 at 14:15

Increase phpMyAdmin upload / import size

By default you get a 2mb limit of upload / import size in phpmyadmin. That makes it odd and highly impossible to import larger files. You can increase the allowed upload size of phpmyadmin by editing your server’s php.ini configuration file. Usually in servers like CentOs it is located at /etc/php.ini.

Step 1: Go to php.ini and find the following and change their values to something more higher than your database size. (In this example i have used 20mb).

upload_max_filesize = 20M

post_max_size = 20M

Step2 : Restart your apache service for this new change to take effect. Usually the command to restart apache would be

service httpd restart (CentOs) / service apache2 restart (ubuntu)

You can also restart directly from their path like

/etc/init.d/apache2 restart or /etc/init.d/httpd restart

If you are in a shared hosting and do not have root access or access to your php.ini configuration file, then the other way is to create a .htaccess file in your application root and add the following line

php_value upload_max_filesize 10M
php_value post_max_size 10M

If you were still not able to increase it, please send me an email for more detailed assistance.

answered Jan 30, 2013 at 20:03

Check your all 3:

• upload_max_filesize
• memory_limit
• post_max_size

in the php.ini configuration file

* for those, who are using wamp @windows, you can follow these steps: *

Also it can be adapted to any phpmyadmin installation.

Find your config.inc.php file for PhpMyAdmin configuration (for wamp it’s here: C:wampappsphpmyadminVERSIONconfig.inc.php

add this line at the end of the file BEFORE «?>»:

$cfg['UploadDir'] = 'C:wampsql';

save

create folder at

C:wampsql 

copy your huge sql file there.

Restart server.

Go to your phpmyadmin import tab and you’ll see a list of files uploaded to c:wampsql folder.

answered Feb 7, 2015 at 9:59

With WAMP, on Windows10, open

c:wamp64aliasphpmyadmin.conf

and change 128 by 256 at the end of these lines

  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M

Restart WAMP

answered Apr 18, 2019 at 21:39

Open this file

edit these parameters:

• memory_limit =128M
• post_max_size = 64M
• upload_max_filesize = 64M

answered Jun 9, 2014 at 6:33

None of the current answers will work for WHM / cPanel servers.

To increase the limit in WHM:

1. Navigate to Server Configuration > Tweak Settings
2. Choose the PHP tab
3. Update «cPanel PHP max POST size» & «cPanel PHP max upload size» (POST size should be bigger)

answered Jun 25, 2015 at 7:54

JatnielJatniel

1,2232 gold badges16 silver badges23 bronze badges

I had the same problem.
My Solution:
go to /etc/phpmyadmin and edit apache.conf
in the <Directory>[...]</Directory> section you can add

php_value upload_max_filesize 10M
php_value post_max_size 10M

Solved the problem for me!

I found the problem and am post hete if anyone followed some blog post out there to create the sort of enviromment I have (win 7 host with ubuntu and zend server ce on virtual box).

The thing is that MySQL is running on Lighttpd, not under Apache. So I had to change the php.ini file under that webserver as well which is in the path:

/usr/local/zend/gui/lighttpd/etc/php-fcgi.ini

In the end, you were right about the files, of course, but I was wrong on what file I had to change

answered Oct 20, 2010 at 6:10

Bart CBart C

1,4292 gold badges15 silver badges17 bronze badges

 php_value upload_max_filesize 100M
    php_value post_max_size 100M

increse that size in php.ini then run command

sudo service apache2 restart
sudo service mysql restart

in xammp

restart all service

answered Feb 24, 2018 at 7:06

answered Dec 16, 2015 at 11:48

FarhanFarhan

1,55114 silver badges12 bronze badges

I was facing the same problem where increasing max size in php.ini has no effect on wordpress and tried many solutions like -:

1. Increase max size via functions.php
2. Increase max size via .htaccess file.

The one that worked for me is adding max size in .htaccess file.
It wasn’t working with neither with php.ini file nor with functions.php file.

I just did add this code in .htaccess file and its done

php_value upload_max_filesize 64M
php_value post_max_size 64M
php_value max_execution_time 300
php_value max_input_time 300

NOTE: I did add above code in <IfModule> tag.

If php.ini file is not doing anything in changing size then try other 2 files for it and one of them will surely work for you.

READ THIS ARTICLE TO KNOW ABOUT ALL FILES IN WHICH YOU CAN INCREASE MAX SIZE

answered Dec 22, 2016 at 4:32

answered Jan 4, 2017 at 10:30

I’ve tried all of the above and nothing worked for me: my phpmyadmin (on wamp) was still showing 128MiB (while I’ve needed to import DB which size was 212Mb)

so if U stucked as me you can import it with the help of commandline:

1. run bash (cmd, powershell or whatever terminal) from folder where your .sql file is located (or cd that path in terminal)
2. run mysql -u username -p database_name < file.sql where
   username — is username for mysql server
   database_name — is name of db you want import to
   file.sql — is name of your sql file

👍😉

for me just worked like a charm after 2hours of trying to manipulate this through php.ini and other configurational files 🙈👌

answered Aug 18, 2021 at 15:04

DebojyotiDebojyoti

4,3072 gold badges19 silver badges27 bronze badges

Arif I.Arif I.

1,8651 gold badge15 silver badges13 bronze badges

Note: (added July 2020)

I’m surprised nobody else has mentioned this … changing php.ini should probably be your last resort when increasing file upload sizes to something as big as 64MB.

It may not matter greatly on development machines, but editing php.ini to globally increase max upload size could be a really bad idea on a server where you have several websites operating. MySQL imports to PHPMyAdmin are often large, but you don’t want every Tom, Dick and Mary uploading 64MB files to another site on your server because you need to do it every now and again for your MySQL database.

I’d suggest a better solution is therefore (assuming you are using the standard Apache PHP module) to edit the specific virtual host configuration for PHPMyAdmin.

On Ubuntu Linux, this is found in /etc/apache2/conf-enabled/
phpmyadmin.conf. On WAMP/Windows/Whatever you’ll need to look at the setup for your Apache configuration, but it will probably be in conf-enabled, conf.d, sites-enabled, or something like that. These are actually often just symlinks to the actual file which is located somewhere like /etc/phpmyadmin/apache.conf (again using Ubuntu as the example here).

Your apache.conf file will include lines something like this:

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
    Options SymLinksIfOwnerMatch
    DirectoryIndex index.php

    # limit libapache2-mod-php to files and directories necessary by pma
    <IfModule mod_php7.c> 
        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
        php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/:/usr/share/php/PhpMyAdmin/:/usr/share/php/Symfony/:/usr/share/php/Twig/:/usr/share/php/Twig-Extensions/:/usr/share/php/ReCaptcha/:/usr/share/php/Psr/Container/:/usr/share/php/Psr/Cache/:/usr/share/php/Psr/Log/:/usr/share/php/Psr/SimpleCache/
    </IfModule>

</Directory>

Immediately after <IfModule mod_php7.c> add these lines:

    php_value post_max_size 64M
    php_value upload_max_filesize 64M

Depending on your server config, you can probably achieve the same thing in an .htaccess file if you prefer. In which case you could just add the two lines by themselves (assuming you know for certain that PHP is enabled).

If you use fpm or fastcgi or something with or without Apache, the same more localized approach to controlling upload sizes can be achieved by using .user.ini files.

answered Jul 25, 2020 at 19:27

quennquenn

616 bronze badges

I am not able to change the file size that phpmyadmin accepts for importing databases on my test server.

I have changed all values I have some idea about in my.cnf:

max_packet_size
Key_buffer

or the upload file size and
max_post_size value in every php.ini file I have found on the system.

The accepted file size on the import screen still remains 8,192kib.

The first things to check (or ask your host provider to check) are the values of max_execution_time, upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP.

Please note that post_max_size needs to be larger than upload_max_filesize.

answered Feb 14, 2018 at 18:14

1. create info.php page and check all details about file

   <?php 
     phpinfo();
   ?>
   

2. run in your browser search upload_max_filesize and post_max_size change by default value 2M to 80M.

3. Run

   sudo -H gedit /etc/php5/apache2/php.ini
   

4. change both values upload_max_filesize and post_max_size
   change by default value 2M to 80M

5. Restart apache

   sudo /etc/init.d/apache2 restart
   

answered Jun 24, 2014 at 14:39

If In case you are using Virtualmin , Webmin or Usermin then

Follow below 2 steps as per image:
1.

2.

answered Dec 9, 2021 at 13:12