Whm increase phpmyadmin upload limit

Question

PHP protects server performance by limiting file upload sizes, but the default limit is too low for many modern web applications. You’re likely to encounter this issue when a PHP application displays an error message asking you to increase the PHP max upload file size. There are various ways to increase the upload limit, including editing PHP configuration files directly. In this article, we’ll show you how to adjust PHP upload limits in cPanel & WHM quickly.

Table of Contents Show

What Is “upload_max_filesize” in PHP?
How to Change the PHP Max Upload Size in WHM?
How do I change max upload size in PHPMyAdmin?
How do I increase max upload size in WHM?
How do I increase mysql import limit?
How do I increase mysql import size in cPanel?

What Is “upload_max_filesize” in PHP?

The upload_max_filesize directive is a PHP variable set in the system and local php.ini files and user.ini files. These determine the PHP interpreter’s baseline configuration. As you might expect, upload_max_filesize limits the maximum allowable size of an uploaded file. The PHP default is 2 Megabytes, and you will have to increase it if you want to upload larger files via a PHP web application.

You may also have to adjust other directives, including:

post_max_size, which must be larger than upload_max_filesize.
memory_limit, which should be larger than post_max_size.

PHP directive values are expressed in bytes. If you set upload_max_filesize to 1000, the maximum size is 1000 bytes. However, you can also use the shorthand byte values K, M, and G for kilobytes, megabytes, and gigabytes. So, 1000K is 1000 kilobytes and 10G is 10 gigabytes.

In cPanel, you can edit PHP directives for locations and domains controlled by your account with the MultiPHP INI Editor, which you will find under Software in the main page menu.

Open the MultiPHP INI editor and select a location from the dropdown.

Scroll to the entry for upload_max_filesize and edit the associated value. Ensure that the value for post_max_size is larger than upload_max_filesize, and click apply at the bottom of the page.

How to Change the PHP Max Upload Size in WHM?

Whereas cPanel allows you to edit PHP directives in local directories, in WHM you can edit directives in the server’s main php.ini file. This affects all accounts using a particular PHP version.

To increase the PHP upload limit in WHM, open MultiPHP INI Editor from the Software section of the sidebar menu. In the dropdown, select a PHP version. PHP versions have independent configurations, so you must edit the max upload variable for all versions you wish to change.

Scroll to upload_max_filesize and edit the adjacent value before clicking Apply at the bottom of the page. Ensure that post_max_size is at least as large.

To learn more about editing PHP directives and what the customizable directives do, take a look at the MultiPHP INI Editor for WHM documentation.

As always, if you have any feedback or comments, please let us know. We are here to help in the best ways we can. You’ll find us on Discord, the cPanel forums, and Reddit. Be sure to also follow us on Facebook, Instagram, and Twitter.

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

H. FerrenceH. Ferrence

7,69631 gold badges94 silver badges159 bronze badges

0

If you are using WHM/Cpanel then in order to change that "Max: 50MiB" limit in the import section of phpmyadmin, you will have to change two values in WHM (Web Host Manager).

Step 1) Go to Tweak settings, find the "cPanel PHP Max upload size" change it according to your needs. Save changes.

Step 2) Go to Tweak settings, find the "cPanel PHP Max POST size" change it according to your needs. Save changes.

Go back to your phpMyadmin. The value should have changed.

answered Oct 17, 2013 at 8:09

SharkySharky

5,9763 gold badges38 silver badges69 bronze badges

9

I had the same problem with my working correctly by doing the following

changes into the php.ini file

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

now restart for the changes to take effect

answered May 8, 2014 at 17:01

Edy AguirreEdy Aguirre

2,03318 silver badges19 bronze badges

2

Could you also increase post_max_size and see if it helps?

Uploading a file through an HTML form makes the upload treated like any other form element content, that's why increasing post_max_size should be required too.

Update : the final solution involved the command-line:

To export only 1 table you would do

mysqldump -u user_name -p your_password your_database_name your_table_name > dump_file.sql

and to import :

mysql -u your_user -p your_database < dump_file.sql

'drop table your_tabe_name;' can also be added at the top of the import script if it's not already there, to ensure the table gets deleted before the script creates and fill it

answered Oct 3, 2012 at 11:53

mbarthelemymbarthelemy

12k4 gold badges39 silver badges42 bronze badges

16

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 phpMyAdmin\libraries\config.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

AbeyAbey

1,39810 silver badges25 bronze badges

I had the same problem. My .sql file was 830 MB and the phpMyAdmin import size allowed was 50MB (just as shown in the screenshot). When I zipped the file to .zip its size became about 80 MB. Then I zipped it to bzip2 format, and I was amazed to see that the file size was compressed to just 12MB (from 830MB to 12MB!!!). As phpMyAdmin allows three compression types i.e. .zip , .gzip and .bzip2 , therefore I uploaded the compressed bzip2 file and viola.... it was imported to the database!!! So by using the right compression, I was able to import a 830MB .sql file into phpMyAdmin.

NOTE: phpMyAdmin import page clearly instructs that the compressed filename should be like filename.sql.bz2 . It should not be like filename.bz2 .

NOTE 2: You can compress your .sql file to bzip2 compressed file using 7-Zip software. cPanel also has an option to compress a file to bzip2 format.

answered Nov 29, 2013 at 6:56

1

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:\wamp64\alias".

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

this is due to file size import limit in phpmyadmin, default is very low, so you should increase upload_max_filesize you can change this in your php.ini, replaced with this

upload_max_filesize = 100M

answered Apr 24, 2015 at 2:26

ramird23ramird23

771 silver badge2 bronze badges

0

You can increase the limit from php.ini file. If you are using windows, you will the get php.ini file from C:\xampp\php directory.

Now changes the following lines & set your limit

post_max_size = 128M
upload_max_filesize = 128M 
max_execution_time = 2000
max_input_time = 3000
memory_limit = 256M

If you have direct root SSH access to the machine you will be able to change the settings in: /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini

Just change the line: upload_max_filesize = 50M

answered Jun 6, 2013 at 17:16

1

if you're using xampp, find the php.ini (in xampp folder itself), go to line 735 and change the post_max_size to the value you wish. ex: if you want to upgrade to 80MiB,

post_max_size = 80M

make sure to restart apache after changing the value.

That's it...

answered Nov 19, 2013 at 22:18

RandikaRandika

1211 silver badge2 bronze badges

1

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

bestshop24hbestshop24h

1112 silver badges8 bronze badges

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

IF YOU ARE USING NGINX :

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

nano php.ini

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

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

Saurabh MistrySaurabh Mistry

11.4k4 gold badges42 silver badges64 bronze badges

I increased the max file size by going to CPanel > Select PHP version > Switch to PHP Extensions and then scroll to the upload_max_filesize field (it will have a clickable link for the size - mine was set at 2MB) and I increased it to 256MB. Then click "Save".

answered May 18, 2015 at 8:39

You Can Search php.ini file in C:\xampp\htdocs

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

Sujiraj RSujiraj R

1,4541 gold badge11 silver badges4 bronze badges

On newer version of cpanel: search ini

size' and edit it...then save[enter

answered May 16, 2017 at 13:32

Mwangi ThigaMwangi Thiga

1,31919 silver badges22 bronze badges

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

How do I change max upload size in PHPMyAdmin?

You can increase the allowed upload size of phpmyadmin by editing your server's php. ini configuration file..

Navigate to Server Configuration > Tweak Settings..

Choose the PHP tab..

Update "cPanel PHP max POST size" & "cPanel PHP max upload size" (POST size should be bigger).

How do I increase max upload size in WHM?

To increase this value on a cPanel server please do the following:.

Login to WHM as root..

Go to Server Configuration » Tweak Settings..

Click on PHP tab..

Update the values `max upload size` and `max POST size` to the max file size you need..

How do I increase mysql import limit?

Show activity on this post..

nano /etc/php5/apache2/php.ini. ... .

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..

restart your apache..

How do I increase mysql import size in cPanel?

Go to PHP Selector, then Options, change values for both these parameters to the size you need it to be (example uses 128M): post_max_size 128M upload_max_size 128M. ... .

The Tweak settings appear, in the find field on the right type: upload size..

Change the cPanel PHP max upload size to what you need and save..

kode php Cpanel change upload_max_filesize PhpMyAdmin 50MB limit