I tried a 6-megabyte excel database import to phpMyAdmin.
The phpMyAdmin collapsed.
The error message is displayed:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2048 bytes) in /users/_public/phpMyAdmin/libraries/PHPExcel/PHPExcel/Reader/Excel5.php on line 2593
Why?
The maximum allowed is 128 MB.
With 0.6 MB al fine.
Hello,
[quote=“beka”]I tried a 6-megabyte excel database import to phpMyAdmin.
The phpMyAdmin collapsed.
The error message is displayed:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2048 bytes) in /users/_public/phpMyAdmin/libraries/PHPExcel/PHPExcel/Reader/Excel5.php on line 2593
Why?
The maximum allowed is 128 MB.[/quote]
These 128MB are for the file UPLOAD and 67’108’864 bytes are MEMORY (RAM) (‘only’ 64MB allowed)
This 6 MB file for import (for conversion, EXCEL->SQL) in to the database needs too much RAM.
//sry 4 my bad (d)english
Greetings fishi
Hello,
please split your file and import then.
The split is not a realy good solution. Should be divided into 10 to 12 pieces or more.
It’s not to easy to seek in with PHP ?
Any other method?
Thank’s a lot.
