Forum Moderators: coopster
PHP Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 393216 bytes) in I:\wamp\apps\phpmyadmin2.11.5\libraries\common.inc.php on line 769
I have a 150mb csv text file that I need to import into MySql, 1 table, 3 columns.
First I tried doing it through phpmyadmin, but received an error that I didn't have enough resources. So i checked out the configuration manual and it recommended the below changes in php.ini
I have changed
memory_limit = 512MB (default was 128)
post_max_size = 150M (default was 8)
upload_max_filesize = 150M (default was 8)
That didn't work so I also added:
php_value memory_limit 32000000
to my .htaccess file but that didn't work.
Then I also added
ini_set("memory_limit","24M");
to index.php for the site I'm working on:
http://example.com/phpmyadmin/
That did not work either. The odd thing is that I put everything back to default and now I'm still getting the same message, even after restarting all the services.
I also tried dumping the file manually into a temp folder so that I can import it by using $cfg['UploadDir'] = ''; option, but nope, nothing.
Anyone got any ideas on this?
[edited by: dreamcatcher at 6:33 am (utc) on April 19, 2008]
[edit reason] Use example.com, thanks. [/edit]
dc
