FrontAccounting forum — Backup file not showing

Re: Backup file not showing

null@example.com (tclim) — Mon, 23 May 2011 13:10:16 +0000

Hi,

You may try this

mysqldump -u root -h localhost -pPassword123 accountdb > /opt/backup/db/accountdb.sql

Where -pPassword123 should you your Password (Remember to append your password just after the -p)

database name: accountdb (Change to your frontaccounting database name)

Hope it help.

Re: Backup file not showing

null@example.com (itronics) — Mon, 23 May 2011 12:57:43 +0000

You can try to change max_execution_time in php.ini to some bigger value. But I guess better solution for very big databases is to use external mysql backup, and not rely on solutions provided by web tools like phpmyadmin or FA builtin backup service.
Janusz

Re: Backup file not showing

null@example.com (popsicles12) — Sat, 21 May 2011 12:49:34 +0000

Hello Joe,

thanks for your reply. To be candid, I believe the files are huge because we sell retails and a lot of little transaction you need to enter. so one has to enter like about 70 to 100 records per day.

So how do I resolve this?

Thanks.

Popsicles12.

Re: Backup file not showing

null@example.com (joe) — Tue, 26 Apr 2011 21:13:32 +0000

Normally the backup routine runs like a charm.
I guess we should look around. You got that when doing a backup.
Do you see any other errors in your errors.log in the /tmp folder?
Is this a huge company? Huge data?

/Joe

Re: Backup file not showing

null@example.com (popsicles12) — Tue, 26 Apr 2011 19:28:08 +0000

hello joe

thanks for your reply.i had to enable the debug feature to let me know what is really happening. This is the error i found.

maximum execution time of 60seconds exceeded in C:\xampp\htdocs\frontaccounts\includes\db\connect_db.inc in line 112.

where do i correct this. I have gone to php.ini file to increase the max_execution_time but to no avail.

please help.

thanks in advance

popsicles12.

Re: Backup file not showing

null@example.com (joe) — Sun, 10 Apr 2011 12:29:19 +0000

It should work allright. Maybe you should upgrade to 2.3.3.

/Joe

Backup file not showing

null@example.com (popsicles12) — Sat, 09 Apr 2011 19:43:03 +0000

Hello Joe,

Thanks for your prompt response to all my questions.

I have a situation right now with backup. When I try to back up, you see the activity bar showing that the backup is being carried out but after some time, the backup is complete but the backup file cannot be found. what do I do.

I was thinking it is the max_execution_time. I increased it and it is still the same thing. there is no error whatsoever. I am using version 2.2.11.

thanks for your response.

popsicles12