FrontAccounting forum — Error Restoring Database

Re: Error Restoring Database

null@example.com (cedricktshiyoyo) — Mon, 15 Jun 2020 18:02:14 +0000

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

null@example.com (apmuthu) — Tue, 08 Oct 2019 05:44:37 +0000

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

null@example.com (Braath Waate) — Mon, 07 Oct 2019 22:42:26 +0000

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

Error Restoring Database

null@example.com (popsicles12) — Mon, 07 Oct 2019 11:48:52 +0000

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