blocks|key|2853172|text|您是否也可以增加post_max_size并查看它是否有帮助？|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2853173|通过超文本标记语言表单上传文件会使上传与其他表单元素内容一样，这就是为什么还需要增加post_max_size的原因。|2853174|更新:最终的解决方案涉及命令行：|2853175|要仅导出1个表，您可以这样做|2853176|mysqldump+-u+user_name+-p+your_password+your_database_name+your_table_name+>+dump_file.sql|code-block|syntax|javascript|2853177|并导入：|2853178|mysql+-u+your_user+-p+your_database+<+dump_file.sql+|2853179|还可以在导入脚本的顶部添加“'drop+table+your_tabe_name；”，以确保在脚本创建和填充该表之前将其删除|2853180|entityMap^0|8|D|0|16|D|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|14|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|15|8|@]|D|@]|E|$]]|$1|L|3|M|5|N|7|16|8|@]|D|@]|E|$O|P]]|$1|Q|3|R|5|6|7|17|8|@]|D|@]|E|$]]|$1|S|3|T|5|N|7|18|8|@]|D|@]|E|$O|P]]|$1|U|3|V|5|6|7|19|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|X|$]]

Could you also increase <code>post_max_size</code> 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 <code>post_max_size</code> should be required too.

Update : the final solution involved the command-line:

To export only 1 table you would do 

<pre><code>mysqldump -u user_name -p your_password your_database_name your_table_name &gt; dump_file.sql
</code></pre>

and to import : 

<pre><code>mysql -u your_user -p your_database &lt; dump_file.sql 
</code></pre>

'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

blocks|key|2853235|text|如果您正在使用WHM/Cpanel，则为了更改phpmyadmin导入部分中"Max:+50MiB“限制，您必须在WHM+(Web主机管理器)中更改两个值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2853236|步骤1)去调整设置，找到"cPanel+PHP最大上传大小“，根据你的需要改变它。保存更改。|2853237|步骤2)去调整设置，找到"cPanel+PHP+size“，根据你的需要改变它。保存更改。|2853238|返回到您的phpMyadmin。该值应该已更改。|2853239|​|2853240|📷|atomic|offset|length|2853241|2853242|2853243|2853244|2853245|2853246|2853247|2853248|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/3aeb40c7585ef395441e76872ba17ad4.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/a5009511638eb8bf335a95276d41ae3b.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/cd533678f0721c069cc48a1de7cdbc84.png^0|0|0|0|0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1A|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1B|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1C|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1D|8|@]|9|@$M|1E|N|1F|1|1G]]|A|$]]|$1|O|3|I|5|6|7|1H|8|@]|9|@]|A|$]]|$1|P|3|I|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Q|3|K|5|L|7|1J|8|@]|9|@$M|1K|N|1L|1|1M]]|A|$]]|$1|R|3|I|5|6|7|1N|8|@]|9|@]|A|$]]|$1|S|3|I|5|6|7|1O|8|@]|9|@]|A|$]]|$1|T|3|K|5|L|7|1P|8|@]|9|@$M|1Q|N|1R|1|1S]]|A|$]]|$1|U|3|I|5|6|7|1T|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12|13|-4]]|14|$5|Y|Z|10|A|$11|15|13|-4]]|16|$5|Y|Z|10|A|$11|17|13|-4]]]]

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.
<img src="https://i.stack.imgur.com/lRHti.png" alt="enter image description here" />
<img src="https://i.stack.imgur.com/bZy1P.png" alt="enter image description here" />
<img src="https://i.stack.imgur.com/U8GRZ.png" alt="enter image description here" />

blocks|key|213728|text|通过执行以下操作，我在正常工作时遇到了同样的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|213729|更改到php.ini文件|213730|post_max_size+=+800M+
upload_max_filesize+=+800M+
max_execution_time+=+5000+
max_input_time+=+5000+
memory_limit+=+1000M+|code-block|syntax|javascript|213731|现在重新启动以使更改生效|213732|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

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

changes into the php.ini file 

<pre><code>post_max_size = 800M 
upload_max_filesize = 800M 
max_execution_time = 5000 
max_input_time = 5000 
memory_limit = 1000M 
</code></pre>

now restart for the changes to take effect

blocks|key|211839|text|在php.ini中更改这些值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|211840|post_max_size+=+750M+
upload_max_filesize+=+750M+
max_execution_time+=+5000+
max_input_time+=+5000+
memory_limit+=+1000M+|code-block|syntax|javascript|211841|然后重新启动Wamp以使更改生效。这需要一些时间。如果您得到以下错误：|211842|211843|脚本超时时间已过，如果要完成导入，请重新提交相同的压缩文件，导入将继续。|blockquote|211844|211845|211846|然后在phpMyAdmin\libraries\config.default.php上更新phpMyAdmin配置|offset|length|style|CODE|211847|/**
+*+maximum+execution+time+in+seconds+(0+for+no+limit)
+*
+*+@global+integer+$cfg['ExecTimeLimit']
+*/
$cfg['ExecTimeLimit']+=+0;|211848|entityMap^0|0|0|0|0|0|0|0|19|A|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|12|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|15|8|@$Q|16|R|17|S|T]]|9|@]|A|$]]|$1|U|3|V|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|X|$]]

Change these values in php.ini

<pre><code>post_max_size = 750M 
upload_max_filesize = 750M 
max_execution_time = 5000 
max_input_time = 5000 
memory_limit = 1000M 
</code></pre>

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

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

Then update the <code>phpMyAdmin</code> configuration, at phpMyAdmin\libraries\config.default.php

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

blocks|key|212361|text|我也有同样的问题。我的.sql文件是830MB，允许的phpMyAdmin导入大小是50MB+(如截图所示)。当我将文件压缩为.zip时，它的大小变成了大约80MB。然后我将其压缩为bzip2+format，我惊讶地看到文件大小被压缩到只有12MB+(从830MB压缩到12MB！)。由于phpMyAdmin支持三种压缩类型，即.zip、.gzip和.bzip2，因此我上传了压缩的bzip2文件和viola...它已导入到数据库中！因此，通过使用正确的压缩，我能够将一个830MB的.sql文件导入到phpMyAdmin中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|212362|注意：+phpMyAdmin导入页面清楚地指示压缩文件名应类似于filename.sql.bz2。它不应该像filename.bz2那样。|212363|注释2:您可以使用7-Zip软件将您的.sql文件压缩为bzip2压缩文件。cPanel还提供了将文件压缩为bzip2格式的选项。|212364|entityMap^0|2J|C|0|0|3|W|G|0|0|4|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|K|$]]

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.

blocks|key|211879|text|首先，您必须根据自己的要求更改php.ini文件中的值。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|211880|post_max_size+=+1024M+
upload_max_filesize+=+1024M+
max_execution_time+=+3600
max_input_time+=+3600+
memory_limit+=+1024M+|code-block|syntax|javascript|211881|注意-请仔细更改这些值。这些值将影响该服务器上的所有项目。|211882|现在，如果上述解决方案不起作用，请检查您的phpmyadmin.conf文件。如果您使用的是"C:\wamp64\alias".中的WAMP，则可以找到该文件|211883|您必须更改下面的值。|211884|文件中已存在的值为-|211885|++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|211886|将上面的代码更改为-|211887|#++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|211888|现在，只需重新启动服务器，即可使用更改后的值。:)|211889|entityMap^0|F|7|0|0|0|T|0|L|F|1A|H|1U|4|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|19|8|@$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1G|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1H|8|@]|D|@]|E|$]]|$1|S|3|T|5|H|7|1I|8|@]|D|@]|E|$I|J]]|$1|U|3|V|5|6|7|1J|8|@]|D|@]|E|$]]|$1|W|3|X|5|H|7|1K|8|@]|D|@]|E|$I|J]]|$1|Y|3|Z|5|6|7|1L|8|@]|D|@]|E|$]]|$1|10|3|-4|5|6|7|1M|8|@]|D|@]|E|$]]]|11|$]]

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

<pre><code>post_max_size = 1024M 
upload_max_filesize = 1024M 
max_execution_time = 3600
max_input_time = 3600 
memory_limit = 1024M 
</code></pre>

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 - 

<pre><code> 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
</code></pre>

Change above code to - 

<pre><code># 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
</code></pre>

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

blocks|key|3066764|text|这是由于phpmyadmin中的文件大小导入限制，默认值非常低，因此您应该增加upload_max_filesize您可以在php.ini中更改此设置，替换为|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3066765|upload_max_filesize+=+100M|3066766|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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

blocks|key|3066787|text|您可以从php.ini文件中增加限制。如果您使用的是windows，您将从C:\xampp\php目录中获取php.ini文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3066788|现在更改以下行&设置您的限制|3066789|post_max_size+=+128M
upload_max_filesize+=+128M+
max_execution_time+=+2000
max_input_time+=+3000
memory_limit+=+256M|code-block|syntax|javascript|3066790|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

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

<pre><code>post_max_size = 128M
upload_max_filesize = 128M 
max_execution_time = 2000
max_input_time = 3000
memory_limit = 256M
</code></pre>

blocks|key|2853182|text|如果您具有对计算机的直接root+SSH访问权限，则可以在:+/usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini中更改设置|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2853183|只需更改行:+upload_max_filesize+=+50M|2853184|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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

blocks|key|209367|text|如果您使用的是xampp，找到php.ini+(在xampp文件夹中)，转到第735行并将post_max_size更改为您希望的值。例如:如果你想升级到80MiB，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|209368|post_max_size+=+80M|209369|请确保在更改该值后重新启动apache。|209370|就这样..。|209371|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

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

blocks|key|3066933|text|转到你的cpanel并搜索"ini+editor“。你会得到"Multiphp+INI编辑器“在那里你选择你的wordpress目录并放入upload_max_filesize+=+256M+post_max_size+=+256M+memory_limit+=+256M|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3066934|​|3066935|📷|atomic|3066936|3066937|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/727569df191f9683d8cbb06a942a18e1.png|imageAlt^0|1X|Q|2O|K|39|J|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|K|3|G|5|6|7|16|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|S|T|-4]]]]

go to your cpanel and search "ini editor". You'll get "Multiphp INI Editor"
There you select your wordpress directory and put
<code>upload_max_filesize = 256M</code> 
<code>post_max_size = 256M</code>
<code>memory_limit = 256M</code>

<a href="https://i.stack.imgur.com/sehOp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sehOp.png" alt="enter image description here"></a>

blocks|key|213757|text|1:nano+/etc/php5/apache2/php.ini|type|unstyled|depth|inlineStyleRanges|entityRanges|data|213758|您可以通过上传一个名为phpinfo.php的文件找到您的php.ini位置，该文件包含以下内容<?php+phpinfo();?>，并通过访问yourdomain.com/phpinfo.php访问它，您将看到结果|offset|length|style|CODE|213759|2:将所需值修改为upload_max_filesize和post_max_size，如:+upload_max_filesize+=+200M+post_max_size+=+300M，则变为200M。|213760|3:重启你的apache|213761|entityMap^0|0|1C|I|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

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<code>&lt;?php phpinfo();?&gt;</code> 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

blocks|key|3066825|text|更改c:/wamp64/+phpmyadmin.conf+/phpmyadmin.conf上的文件别名|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3066826|php_admin_value+upload_max_filesize+512M|3066827|php_admin_value+post_max_size+512M|3066828|php_admin_value+max_execution_time+360|3066829|php_admin_value+max_input_time+360|3066830|将时间增加到5000或更高是非常重要的，因此，当你上传一个大文件时，这个过程不会停止。|3066831|这对我很有效。|3066832|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

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.

blocks|key|3066961|text|请确保您正在编辑php.ini而不是php-development.ini或php-production.ini，php.ini文件类型是配置设置，当您在编辑器中编辑它时，它会显示.ini扩展名。你可以在这里找到php.ini：xampp/php/php|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3066962|然后|3066963|upload_max_filesize+=+128M
post_max_size+=+128M
max_execution_time+=+900
max_input_time+=+50000000
memory_limit+=+256M|code-block|syntax|javascript|3066964|​|3066965|📷|atomic|3066966|3066967|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/5bf156c77989cae69a33ae8473d32e87.png|imageAlt^0|36|D|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|14|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|15|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|16|8|@]|D|@]|E|$]]|$1|O|3|P|5|Q|7|17|8|@]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|R|3|N|5|6|7|1B|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z|10|-4]]]]

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

<pre><code>upload_max_filesize = 128M
post_max_size = 128M
max_execution_time = 900
max_input_time = 50000000
memory_limit = 256M
</code></pre>

<img src="https://i.stack.imgur.com/tZ4Tc.png" alt="enter image description here]">

blocks|key|3066972|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3066973|如果您使用的是NGINX：|blockquote|3066974|3066975|3066976|3066977|cd+/etc/php/<PHP_VERSION>/fpm示例=>+cd+/etc/php/7.2/fpm|ordered-list-item|offset|length|style|CODE|BOLD|3066978|3066979|3066980|nano+php.ini|3066981|3066982|post_max_size+=+1024M+upload_max_filesize+=+1024M+max_execution_time+=+3600+max_input_time+=+3600+memory_limit+=+1024M+|3066983|3066984|保存php.ini文件后，使用以下命令重新启动fpm：|3066985|3066986|systemctl重新启动php-fpm|3066987|示例=>+系统fpm重新启动php7.2-fpm|3066988|entityMap^0|0|0|0|0|0|0|T|Y|J|0|0|0|0|C|0|0|0|0|0|0|0|5|J|0^^$0|@$1|2|3|-4|4|5|6|15|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|16|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|17|7|@]|8|@]|9|$]]|$1|E|3|-4|4|5|6|18|7|@]|8|@]|9|$]]|$1|F|3|-4|4|5|6|19|7|@]|8|@]|9|$]]|$1|G|3|H|4|I|6|1A|7|@$J|1B|K|1C|L|M]|$J|1D|K|1E|L|N]]|8|@]|9|$]]|$1|O|3|-4|4|5|6|1F|7|@]|8|@]|9|$]]|$1|P|3|-4|4|5|6|1G|7|@]|8|@]|9|$]]|$1|Q|3|R|4|I|6|1H|7|@$J|1I|K|1J|L|M]]|8|@]|9|$]]|$1|S|3|-4|4|5|6|1K|7|@]|8|@]|9|$]]|$1|T|3|U|4|5|6|1L|7|@]|8|@]|9|$]]|$1|V|3|-4|4|5|6|1M|7|@]|8|@]|9|$]]|$1|W|3|X|4|I|6|1N|7|@]|8|@]|9|$]]|$1|Y|3|-4|4|5|6|1O|7|@]|8|@]|9|$]]|$1|Z|3|10|4|5|6|1P|7|@]|8|@]|9|$]]|$1|11|3|12|4|5|6|1Q|7|@$J|1R|K|1S|L|N]]|8|@]|9|$]]|$1|13|3|-4|4|5|6|1T|7|@]|8|@]|9|$]]]|14|$]]

<blockquote>
IF YOU ARE USING NGINX :
</blockquote>
<ol>
<li><code>cd /etc/php/&lt;PHP_VERSION&gt;/fpm</code> example =&gt; cd /etc/php/7.2/fpm
</li>
<li><code>nano php.ini</code>
<pre><code>post_max_size = 1024M 
upload_max_filesize = 1024M 
max_execution_time = 3600 
max_input_time = 3600 
memory_limit = 1024M 
</code></pre>
</li>
<li>after saving php.ini file , restart fpm using :
<pre><code>systemctl restart php&lt;PHP_VERSION&gt;-fpm
</code></pre>
</li>
</ol>
example =&gt; systemctl restart php7.2-fpm

blocks|key|209390|text|我通过转到CPanel+>选择PHP版本>切换到PHP扩展名来增加最大文件大小，然后滚动到upload_max_filesize字段(它将有一个可点击的大小链接-我的设置为2MB)，我将其增加到256MB。然后点击“保存”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|209391|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|2853329|text|您可以在C:\xampp\htdocs中搜索php.ini文件|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2853330|更改到php.ini文件|2853331|post_max_size+=+805M+
upload_max_filesize+=+805M+
max_execution_time+=+5005+
max_input_time+=+5005+
memory_limit+=+1005M+|code-block|syntax|javascript|2853332|编辑完成后，请重新启动XAMPP|2853333|entityMap^0|4|F|M|7|0|3|7|0|0|B|5|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|P|$]]

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

changes into the php.ini file

<pre><code>post_max_size = 805M 
upload_max_filesize = 805M 
max_execution_time = 5005 
max_input_time = 5005 
memory_limit = 1005M 
</code></pre>

After editing Please restart XAMPP

blocks|key|212424|text|在更新版本的cpanel上:+search+ini|type|unstyled|depth|inlineStyleRanges|entityRanges|data|212425|​|212426|📷|atomic|offset|length|212427|212428|212429|212430|size‘和编辑it...then保存[enter|212431|212432|212433|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/844501ab2d96a30b4e3b9f640f7bde7b.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/32fea8c769fe4bff373095b8fac593fb.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/f23ac2d1a8dccf8d0a35fcacd5e3cfb3.png^0|0|0|0|1|0|0|0|0|0|1|1|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@$G|15|H|16|1|17]]|A|$]]|$1|I|3|C|5|6|7|18|8|@]|9|@]|A|$]]|$1|J|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|K|3|E|5|F|7|1A|8|@]|9|@$G|1B|H|1C|1|1D]]|A|$]]|$1|L|3|M|5|6|7|1E|8|@]|9|@]|A|$]]|$1|N|3|E|5|F|7|1F|8|@]|9|@$G|1G|H|1H|1|1I]]|A|$]]|$1|O|3|C|5|6|7|1J|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W|X|-4]]|Y|$5|S|T|U|A|$V|Z|X|-4]]|10|$5|S|T|U|A|$V|11|X|-4]]]]

On newer version of cpanel: search ini

<a href="https://i.stack.imgur.com/gvYDC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gvYDC.png" alt="Select the Home Directory"></a>

<a href="https://i.stack.imgur.com/KBrEs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KBrEs.png" alt="Scrool down to &#39;upload_max_file"></a>size' and edit it...then save[enter 
<a href="https://i.stack.imgur.com/yBces.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yBces.png" alt="enter image description here"></a>

blocks|key|211913|text|Sharky的回答恰到好处。显示的phpMyAdmin上载文件大小不受php.ini设置的管理，当您运行包含以下内容的phpinfo.php时，可以看到这些设置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|211914|<?php
//+Show+all+information,+defaults+to+INFO_ALL
phpinfo();
?>|code-block|syntax|javascript|211915|增加以下各项的php.ini设置是一种良好的做法：|211916|post_max_size+upload_max_filesize+max_execution_time+max_input_time+memory_limit|211917|您可以使用Sujiraj+R分享的设置示例。一旦您对php.ini和WHM的“调整设置”区域进行了所有更改，当您启动phpMyAdmin并进入导入屏幕时，您将看到您为"cPanel+PHP最大上传大小“字段选择的大小。|211918|在这篇文章中有很多好的答案，但你必须反复查看才能得到正确的答案。我希望通过将之前的答案封装在这篇文章中，我能提供一点帮助。我在这篇文章中提到的所有答案都是由这里发布的其他人得出的，所以请不要相信我在这里发布的任何答案。|211919|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

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:

<pre><code>&lt;?php
// Show all information, defaults to INFO_ALL
phpinfo();
?&gt;
</code></pre>

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.

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 <code>upload_max_filesize</code> 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.
<img src="https://i.stack.imgur.com/wMTSA.jpg" alt="enter image description here">
Screen Shot #2 -- showing the phpMyAdmin import restriction
<img src="https://i.stack.imgur.com/9iawi.jpg" alt="enter image description here">

How to Increase Import Size Limit in phpMyAdmin

数据库

服务器

有人知道您是否可以或如何提高phpMyAdmin中的导入大小限制吗？目前，我的服务器被限制为50MB。请注意，这与php.ini中的upload_max_filesize不同。该值设置为2MB。我需要将一个表导入到我的一个数据库中，而导入时phpMyAdmin对50MB的限制阻止了我这样做。谢谢。修正--附2张截图：显示php.ini设置的屏幕截图#1 -- phpinfo()。屏幕截图#2 --

问如何提高phpMyAdmin中的导入大小限制
EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何提高phpMyAdmin中的导入大小限制EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何提高phpMyAdmin中的导入大小限制
EN