blocks|key|2993549|text|使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2993550|c:\mysql\bin\>+mysql+-u+username+-p+password+database_name+<+filename.sql|code-block|syntax|javascript|2993551|使用命令行导入|2993552|或在php.ini中|2993553|memory_limit+=+256M|2993554|将其更改为其他更大的值。但正如Dan所说，使用命令行更可取。|2993555|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|D|7|U|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

use this :

<pre><code>c:\mysql\bin\&gt; mysql -u username -p password database_name &lt; filename.sql
</code></pre>

to import using command line 

or
 in php.ini 

<pre><code>memory_limit = 256M
</code></pre>

change this to some other larger value. But as Dan said using command line is preferable.

blocks|key|2993613|text|phpMyAdmin最近一直在突破我的内存限制(我甚至没有导入/执行大量数据)，所以我在我的config.inc.php中尝试了以下方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2993614|$cfg['MemoryLimit']+=+'128M';|code-block|syntax|javascript|2993615|https://docs.phpmyadmin.net/en/latest/config.html#cfg_MemoryLimit|offset|length|2993616|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|1T|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|T|8|@]|9|@$I|U|J|V|1|W]]|A|$]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|H]]]]

phpMyAdmin has been blowing memory limits on me lately (and I wasn't even importing/executing large amounts of data) so I've just tried the following in my config.inc.php

<pre><code>$cfg['MemoryLimit'] = '128M';
</code></pre>

<a href="https://docs.phpmyadmin.net/en/latest/config.html#cfg_MemoryLimit" rel="nofollow noreferrer">https://docs.phpmyadmin.net/en/latest/config.html#cfg_MemoryLimit</a>

blocks|key|3207110|text|尝试这个http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html，我能够导入一个930MB的数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3207111|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html^0|4|1J|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Try this <a href="http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html</a> I was capable to import a 930 MB database.

blocks|key|3207147|text|正如其他答案所提到的，您可以更改php.ini。这在你的本地主机上是可以的。但是在具有更多虚拟主机的does服务器上，您可能不希望增加所有主机的内存限制(这就是php.ini中的指令所做的)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3207148|要仅增加给定虚拟主机的内存限制，请编辑虚拟主机设置。例如：|3207149|<VirtualHost+*:443>
+++#your+virtualhost+settings
+++php_value+memory_limit+64M+#place+any+number+you+need
</VirtualHost>|code-block|syntax|javascript|3207150|或者，您可以将相同的php_value放入您的.htaccess文件中，但您的虚拟主机必须允许更改此值。|3207151|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|$]]

You can change php.ini as other answers have mentioned. It can be ok on you localhost. But on webserver with more virtualhost you probably don't want to increase memory limit for all hosts (that's what directive in php.ini does).

To increse memory limit only for given virtualhost edit virtualhost settings. For example:

<pre><code>&lt;VirtualHost *:443&gt;
 #your virtualhost settings
 php_value memory_limit 64M #place any number you need
&lt;/VirtualHost&gt;
</code></pre>

Or, you can place the same php_value into your .htaccess file, but your virtualhost must allow to change this values.

blocks|key|285655|text|我在迁移数据库时也遇到了同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|285656|尝试使用如下查询将导出的配置更改为生成文件：|285657|INSERT+INTO+tbl_name+VALUES+(1,2,3)|code-block|syntax|javascript|285658|当我创建像这样的查询时：|285659|INSERT+INTO+tbl_name+(col_A,col_B)+VALUES+(1,2,3),+(4,5,6),+(7,8,9)|285660|查询太大，无法在内存中分配它们。当我改变它的时候，有很多小的查询，所以没有内存问题。|285661|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|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I was the same problem with the migration of database.

Try to change configuration of export to build file with queries like this:

<pre><code>INSERT INTO tbl_name VALUES (1,2,3)
</code></pre>

When I was creating queries like this one:

<pre><code>INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)
</code></pre>

queries were too big to allocate them in memory. 
When I changed it, there were a lot of small queries so there wasn't problem with memory.

blocks|key|3207262|text|在我的例子中，它的工作方式是在文件php.ini中指定pcre.jit=0。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3207263|entityMap^0|H|7|R|A|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

In my case, it works by specifying <code>pcre.jit=0</code> in the file <code>php.ini</code>.

blocks|key|282124|text|使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|282125|编辑您的php.ini文件:更改|282126|memory_limit+=+256M|code-block|syntax|javascript|282127|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|$]]

Use this :

Edit your php.ini file: Change

<pre><code>memory_limit = 256M
</code></pre>

I am facing some problem when I am trying to import magento database on localhost. It just import 18 table but in actual it contain 383 approx table. It gives error given below

<blockquote>
 Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 2089674 bytes) in /usr/share/phpmyadmin/libraries/import.lib.php on line 253
</blockquote>

How this problem will configure.
Is there need to change <code>php.ini</code>?

How to increase memory size for phpmyadmin

虚拟主机

数据库

服务器

当我试图在本地主机上导入magento数据库时，我遇到了一些问题。它只导入18个表，但实际上它包含大约383个表。它给出了下面的错误致命错误:第253行的/usr/share/phpmyadmin/libraries/import.lib.php中允许的内存大小为16777216字节已耗尽(尝试分配2089674字节)此问题将如何配置。是否需要更改php.ini

问如何为phpmyadmin增加内存大小
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何为phpmyadmin增加内存大小EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何为phpmyadmin增加内存大小
EN