#342 Memory exhaustion when importing large SQL file

3.7.0
open
nobody
memory (1)
5
2014-04-16
2013-09-22
Jáchym Toušek
No

When importing large SQL file (about 50 MB) I get the following error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 44895042 bytes) in /adminer.php on line 83.

I'm using Adminer 3.7.1 and have memory_limit 128M. I've tried several times with the same results.

Discussion

  • Jakub Vrána
    Jakub Vrána
    2013-09-28

    Can you share the file? Adminer should be able to import files even bigger than memory_limit.

     
  • Sure. I'll e-mail it to you.

     
  • I can confirm the same issue with version 4.0.3 on line 85 ... the code uses file_get_contents when working with the file, resulting in memory exhaustion.
    My file is gzipped (using Adminer export): 14MB compressed, 82MB uncompressed.