Search code examples
phpmyadminxampp

Fatal error: Out of memory (allocated 761004032) (tried to allocate 755370216 bytes) in D:\xampp\phpMyAdmin\libraries\zip_extension.lib.php on line 55

Am trying to import 120MB size database.zip file in xampp PHPMyAdmin. I'm increse following in php.ini

memory_limit=1200M

upload_max_filesize=1200M

post_max_size=1100M

max_input_time=5000

But still i got error

Fatal error: Out of memory (allocated 761004032) (tried to allocate 755370216 bytes) in D:\xampp\phpMyAdmin\libraries\zip_extension.lib.php on line 55

How can i fix this ?

Note: Original database.sql file size is 750MB

Solution

  • Try this: Open cmd

    Type cd c:\xampp\mysql\bin and press enter.

    After that type this following code:

    mysql -u root -p database_name < database.sql

    Note: Before this copy and paste your databse.sql file in C:\xampp\mysql\bin