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
Thank you for your input, I think I'm better of hiring someone knows what he's doing.
Marry Christmas!
Eric
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.
check file and folder permissions and db user permissions.
The permissions are fine.
Is there a error log we can check?
company/0/backup/
company/1/backup/
..
..The path is set in the config.php file.
]]>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?
I can't create backup from"Backup and Restore Database" page recently. It worked fine last time!
Please help.
Thank you.
Eric