Backing up OpenEMR using fullbackup4_sh

Management and Administration
1

Hi,

I’d like to use the fullbackup4_sh script to backup OpenEMR that is supplied on the wiki here: http://www.open-emr.org/wiki/index.php/OpenEMR_Backup_Tools. I like the idea of having an automated backup of the web directory and database to DVD and on the local directory. When I run the script, the web directory gets backed up fine, but the mysqldump gives the error 1045: Access denied for user root @ localhost (using password: NO) when trying to connect. It seems to be getting hung up on mysqldump, as when I run mysqldump --opt -p openemr and enter the MySQL root password, it dumps. I am running the script as root. Obviously the script would be running as a non-interactive task, so I can’t always be putting in the password. I researched using the mysql_config_editor utility to solve the issue, but I’m out of my league in getting it to work. Any ideas?

-Venu

2

Hi @vrjula,
To create a password less authentication in mysql, you can check on the following link. Kindly let us know if you need more information.

Thanks,
ViSolve

3

Hi @visolveemr,

Yes, this was the article I used. I tried the utility again by doing something a little different, and sure enough it works.

I guess when you work hours at something, your mind no longer thinks straight. Thanks for helping me refocus!

–Venu

4

@vrjula Glad it works :+1:

Thanks,
ViSolve OpenEMR Support Team