Backup Error on new CVS install

Management and Administration
1

aperezcrespo wrote on Tuesday, February 03, 2009:

Hi
I just installed this and either I’m tired or getting stupid.
This is from the backup option on the menu.
No errors reported with the MYSQL files.
“PGPASSWORD=‘mypassword’ pg_dump -U ‘sql-ledger’ -h localhost --format=c -f /tmp/openemr_web_backup/emr_backup/sql-ledger.sql ‘sql-ledger’” returned 1

Any clues?

Thanks

2

cfapress wrote on Tuesday, February 03, 2009:

I’d guess that it’s trying to backup SQL-Ledger but you don’t have it installed.

The backup script looks for the folder ‘sql-ledger’ inside the OpenEMR folder. Chances are good that you have it there. But! There’s no sql-ledger database installed. If you’re not going to use SQL-Ledger for account then you could simply rename the ‘sql-ledger’ folder to something else such as ‘no-sql-ledger’.

Then try the backup again and see what happens.

Personally, I’ve never used the Accounting portion of OpenEMR so this is all based on code inspection and conjecture.

Jason

3

aperezcrespo wrote on Thursday, February 05, 2009:

OOPS

SQL-Ledger Database name in globals.php typo

Thanks