How to increase memory size for phpmyadmin
use this :
c:\mysql\bin\> mysql -u username -p password database_name < filename.sqlto import using command line
or in php.ini
memory_limit = 256Mchange this to some other larger value. But as Dan said using command line is preferable.
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
$cfg['MemoryLimit'] = '128M';https://docs.phpmyadmin.net/en/latest/config.html#cfg_MemoryLimit
Try this http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html I was capable to import a 930 MB database.