FrontAccounting forum — Backup and Restore Database

Re: Backup and Restore Database

null@example.com (ericta) — Tue, 23 Dec 2014 17:59:42 +0000

Someone sent me this command script

mysqldump --host="hostingAddress" --user="databaseUserName" --password="databasePassword" "databaseName" | gzip > "~/frontaccounting_$(date +%Y%m%d).sql.gzip"

I used it in crontab, it works great.

Thank you for your help.
Eric

Re: Backup and Restore Database

null@example.com (ericta) — Sat, 20 Dec 2014 20:10:59 +0000

Hi apmuthu,

Thank you for your input, I think I'm better of hiring someone knows what he's doing.
Marry Christmas!

Eric

apmuthu wrote:

List what permissions your DB User has for the specific FA DB.
Provide versions of PHP, MySQL and Apache used and what platform / OS your server is on (Windows, Linux, etc)?
What is the file ownerships and permissions of the folders / files in the webroot and what is your webserver user:group?
Apache error logs will be based on your apache conf file used - check in /var/log/apache2/error*log or /var/log/httpd/error*log in Linux. PHP Errors in FA are generally found in tmp/ folder under the webroot.

Re: Backup and Restore Database

null@example.com (apmuthu) — Sun, 23 Nov 2014 12:06:04 +0000

List what permissions your DB User has for the specific FA DB.
Provide versions of PHP, MySQL and Apache used and what platform / OS your server is on (Windows, Linux, etc)?
What is the file ownerships and permissions of the folders / files in the webroot and what is your webserver user:group?
Apache error logs will be based on your apache conf file used - check in /var/log/apache2/error*log or /var/log/httpd/error*log in Linux. PHP Errors in FA are generally found in tmp/ folder under the webroot.

Re: Backup and Restore Database

null@example.com (ericta) — Sat, 22 Nov 2014 21:39:39 +0000

apmuthu wrote:

check file and folder permissions and db user permissions.

The permissions are fine.
Is there a error log we can check?

Re: Backup and Restore Database

null@example.com (apmuthu) — Fri, 21 Nov 2014 08:49:51 +0000

check file and folder permissions and db user permissions.

Re: Backup and Restore Database

null@example.com (ericta) — Tue, 18 Nov 2014 19:39:44 +0000

Yup, No backup generated in the directory.
That's not good...

Re: Backup and Restore Database

null@example.com (apmuthu) — Sun, 16 Nov 2014 09:21:01 +0000

company/0/backup/
company/1/backup/
..
..

The path is set in the config.php file.

Re: Backup and Restore Database

null@example.com (ericta) — Sat, 15 Nov 2014 21:25:50 +0000

dz wrote:

What error it shows?

The progress bar runs for a while and stops with no new sql file appears in the right script window.
Where's the backup sql file save anyway?

Backup and Restore Database

null@example.com (ericta) — Sat, 19 Apr 2014 16:55:04 +0000

Hi all,

I can't create backup from"Backup and Restore Database" page recently. It worked fine last time!
Please help.

Thank you.
Eric