How to Increase Import Size Limit in phpMyAdmin

A

21

81

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. enter image description here Screen Shot #2 -- showing the phpMyAdmin import restriction

Atkins answered 3/10, 2012 at 11:45 Comment(2)

youtu.be/LKEZPVujTgI see here – Treenatreenail 24/8, 2023 at 6:49

#9593628 – Padrone 18/4 at 8:25

I

50

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

Irreversible answered 3/10, 2012 at 11:53 Comment(16)

Thanks @mbathelemy. First off it is not a php.ini issue with post_max_size. That value is set to 8M. I have added screen shots to my question to show exactly what I am referring too. Please note that the SysAdmin at the hosting company told me that value can't be changed. I find that hard to believe. Did the developer(s) of phpMyAdmin hard code this restriction with no option to change? – Atkins 3/10, 2012 at 12:8

If you think you will hit problems while importing your file because of the 50MC phpmyadmin limit, you WILL also hit the php.ini limits before (since they are set to values much lower than 50MB) – Irreversible 3/10, 2012 at 12:26

Thanks @mbarthelemy, but I am not clear on your comment. What is interesting is that I am in the process of exporting and importing an entire DB with 17 tables. All 17 tables total approx 80MB. One table totals 50.5MB (doesn't that figure). So when I batch the other 16 tables they total about 30MB and I was able to import them with no problem. Hence the 8M post_max_size does not come into play, and the 2M upload_max_filesize does not come into play either. Only the 50MB phpMyAdmin restriction comes into play. – Atkins 3/10, 2012 at 12:31

@H.Ferrence thanks a lot for this additional information. Unfortunately, and I'm sorry about that, I still think that the root of your problem is a configuration value that limits you. If the values of php.ini are ignored, they are probably overriden somewhere (inside phpmyadmin config?) Also, did you try to compress the file you import to reduce its size, since it seems to be supported by phpmyadmin? – Irreversible 3/10, 2012 at 12:44

Thanks @Irreversible -- the imported files are compressed and zipped at the sizes I stated earlier. I mean, I am onto every aspect of what I need to do, how to do it, what the parameters and restrictions are, etc. I am just needing to know how and where the developers for phpMyAdmin set the 50MB restriction level and how I can change it (if at all). – Atkins 3/10, 2012 at 13:7

(continued) Still - I find it hard to believe that a tool as powerful and sophisticated as phpMyAdmin is, that the developer(s) overlooked this one little detail. Somehow/somewhere they plugged in the value of 50MB and believe me their tool checks that value and rejects the import if the incoming file size exceeds 50MB. – Atkins 3/10, 2012 at 13:8

Maybe it's not the original developers. I googled a bit and phpmyadmin doesn't seem to override php.ini settings (at least no those related to upload and form data size). Do you use a Phpmyadmin provided (and maybe 'tuned') by a hosting company, or did you setup it yourself? – Irreversible 3/10, 2012 at 13:10

installed by hosting company. plus I googled and searched the entire phpMyAdmin forum. There are numerous questions asked there exactly on the same issue I am asking about. And believe it or not, every single question went unanswered. Changing the phpMyAdmin limit seems to be a huge mystery. – Atkins 3/10, 2012 at 13:13

I know it's definitely the direct solution to your question, but did you consider managing your import/exports from command line? It would save you some time and headaches.. Do you have something like an SSH access to your database? – Irreversible 3/10, 2012 at 13:20

I do have SSH access @mbarthelemy. I was trying to use the phpMyAdmin tool for streamlining purposes. I am not completely clear on the commands to use at the command line to import my exported DB Tables. – Atkins 3/10, 2012 at 13:29

The commands would be very easy: 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 – Irreversible 3/10, 2012 at 13:34

Ok, thanks @mbarthelemy. Will the import completely overwrite the existing tables in the DB that is already setup on the target server? I want it to overwrite completely. – Atkins 3/10, 2012 at 13:37

I'm sorry, I don't have a mysql access right now. you can test and see if the table is automatically deleted when you import. If not, you can add 'drop table your_table' at the top of the exported .sql file. Also, as the problem was initially about getting phpmyadmin to work, maybe you can check the phpmyadmin config file (which should be named like 'config.something.inc') for php config values, since you have an SSH access? – Irreversible 3/10, 2012 at 13:46

Awesome @Irreversible -- your command line import worked ! Well, I know you knew it would, but it was the solution to my server-side restriction... – Atkins 6/10, 2012 at 11:42

@H.Ferrence glad to know I helped you! I updated my answer with the final solution, even if it's not a real one, given that the initial question was about phpmyadmin – Irreversible 6/10, 2012 at 12:8

Changing post_max_size fixed the issue for me on localhost on lamp. – Pie 21/11, 2013 at 7:45

A

74

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.

enter image description here

Antechamber answered 17/10, 2013 at 8:9 Comment(3)

This did not work for me at first, I had to reboot the whole server for it to update for phpmyadmin, once done though it worked. Thanks – Piccolo 27/11, 2016 at 1:57

Cpanel updated guide on this, roughly the same thing: support.cpanel.net/hc/en-us/articles/… – Padrone 18/4 at 9:16

Compressing the file might be an obvious step but helps a lot. Whether using phpMyAdmin or in command line this can make a big difference. Personally, my SQL file shrank from ~1 gb to just ~80 mb. Irfan Ullah Khan's answer explains more. – Padrone 23/4 at 11:25

M

71

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

Majordomo answered 8/5, 2014 at 17:1 Comment(2)

On my local phpmyadmin environment, I only had to modify post_max_size and restart apache. The new size was then shown in the phpmyadmin "File to import" section. But I suppose if your server is remote and/or your upload file is large, you'll want to change those other values. – Thales 2/11, 2015 at 17:27

you need to update max_allowed_packet on my.ini at C:\xampp\mysql\bin\my.ini – Hydrothorax 24/1, 2022 at 12:46

I

50

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