FrontAccounting forum — Error Restoring Database

Re: Error Restoring Database

2020-06-15T18:02:14Z

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.

Re: Error Restoring Database

2019-10-08T05:44:37Z

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

2019-10-07T22:42:26Z

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

Error Restoring Database

2019-10-07T11:48:52Z

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