How to increase memory size for phpmyadmin

Question

I am having a problem when I try to import a magento database on localhost. It simply imports 18 tables, but in reality it contains 383 approximate tables. It gives the error below

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

How this problem will be configured. Do I need to change php.ini?

Answer 1

use this:

c:\mysql\bin\> mysql -u username -ppassword database_name < filename.sql

for import using the command line

or in php.ini

memory_limit = 256M

change this to another larger value. But, as Dan said, using the command line is preferable.

Answer 2

PHPMyAdmin ( / ), config.inc.php

$cfg['MemoryLimit']             = '128M';

http://wiki.phpmyadmin.net/pma/Config#MemoryLimit

Answer 3

http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html 930 .

Answer 4

php.ini, . localhost. - , , ( php.ini ).

. :

<VirtualHost *:443>
   #your virtualhost settings
   php_value memory_limit 64M #place any number you need
</VirtualHost>

php_value .htaccess , .

Answer 5

.

, :

INSERT INTO tbl_name VALUES (1,2,3)

, :

INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)

, . , , .

Answer 6

:

php.ini:

memory_limit = 256M