Backup error - folder permissions?

writecraft wrote on Wednesday, July 03, 2013:

Hi, I click the Administration > Backup > Create Backup button, and get this error:
Dumping OpenEMR database…
“/usr/bin/mysqldump -u ‘openemrDBname’ -p’*****’ -h’mysql55.web6.luxsci.com’ --opt --quote-names -r /tmp/openemr_web_backup/emr_backup/openemr.sql ‘openemrDBname’” returned -1:

I tried creating the /tmp/openemr_web_backup/emr_backup/ folders manually and made them writable, but still get the same error. Open EMR is installed on a Linux Web Server, and I’m pretty sure backup worked before I upgraded to 4.1.1. Any suggestions?

Is it something in the global settings? Here is the phpinfo: https://myhealthbilling.com/phpinfo.php

Thanks!

visolveemr wrote on Wednesday, July 03, 2013:

Hi,
This looks like an issue with linux/mysql configuration.

The command “/usr/bin/mysqldump -u ‘openemrDBname’ -p’*’ -h’mysql55.web6.luxsci.com’ --opt --quote-names -r /tmp/openemr_web_backup/emr_backup/openemr.sql ‘openemrDBname’” should return 0 on successful execution. But it returns -1.

You can try executing the same command via terminal to get detailed error message.

Note: On successful execution of the above command, a new file “/tmp/openemr_web_backup/emr_backup/openemr.sql” will be created.

Thanks
Your OpenEMR Customization/Support provider,
ViSolve,Inc
services@visolve.com