How to Increase Import Size Limit in phpMyAdmin

Question

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

User · Answer

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 lt  php phpinfo     gt  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

User · Answer

On newer  version of cpanel  search ini    size  and edit it   then save enter

User · Answer

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

User · Answer

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

User · Answer

If you are using WHM Cpanel then in order to change that  quot Max  50MiB quot  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  quot cPanel PHP Max upload size quot  change it according to your needs  Save changes  Step 2  Go to Tweak settings  find the  quot cPanel PHP Max POST size quot  change it according to your needs  Save changes  Go back to your phpMyadmin  The value should have changed

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

IF YOU ARE USING NGINX     cd  etc php  lt PHP VERSION gt  fpm example   gt   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 lt PHP VERSION gt -fpm    example   gt  systemctl restart php7 2-fpm

User · Answer

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

User · Answer

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    lt  php    Show all information  defaults to INFO ALL phpinfo      gt    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

User · Answer

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  amp  set your limit  post max size   128M upload max filesize   128M  max execution time   2000 max input time   3000 memory limit   256M

User · Answer

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

User · Answer

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  gt  dump file sql   and to import     mysql -u your user -p your database  lt  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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

[phpmyadmin] How to Increase Import Size Limit in phpMyAdmin

Examples related to phpmyadmin