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\ 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.


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

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.

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.