• From: Nigeria
  • Registered: 09/08/2007
  • Posts: 124

Topic: Error Restoring Database

Hello apmuthu,

I tried restoring my database which is about 135MB but I have this error "Allowed memory size of 335544320 bytes exhausted (tried to allocate 24 bytes) in C:\xampp\htdocs\frontaccount\admin\db\maintenance_db.inc on line 326".

how do I correct this error to make sure my database is restored.

I have increase the max upload file size but to no avail.

kindly help.

thanks
Popsicles12

  • From: USA
  • Registered: 07/16/2017
  • Posts: 276

Re: Error Restoring Database

Google php memory_limit.  Update your php.ini file and restart web server.

See also, 0004745: Restore dies with php memory error

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Error Restoring Database

You can do a restore using PHPMyAdmin or other SQL client if very large.

Large DB Restore will need to be re-written in FA 2.5.

apmuthu's Website

  • From: Addis Ababa, Ethiopia
  • Registered: 11/28/2019
  • Posts: 109

Re: Error Restoring Database

With xampp I think you need to use the full path at the command line, something like this, perhaps:

C:\xampp\mysql\bin\mysql -u {username} -p {database name} < file_name.sql

On Windows this should work (note the forward slash and that the whole path is not quoted and that spaces are allowed)

USE your db;

SOURCE D:/My Folder with spaces/Folder/file to import.sql;

Hope this help.

For large databases, you need to import from command line.  do not use phpmyadmin.