emhi wrote on Monday, April 09, 2012:
When I want to run Backup I get this message “”/usr/bin\mysqldump -u “openemr” -p"escargot" -h"localhost" -opt -quote-names -r C:\Users\user\AppData\Local\Temp/openemr_web_backup/emr_backup/openemr.sql “openemr”" returned 1: "
and I cannot back up. This happened after updating to last patch 9. I use Xampp.I would appreciate any help with this
tmccormi wrote on Monday, April 09, 2012:
"/usr/bin\mysqldump … is definately NOT the right path to your mysqldump for a windows XAMPP install.
You’ll need to look at your pre-upgrade backup and figure out what it should be.
-Tony
emhi wrote on Monday, April 09, 2012:
Tony
Do you know how I check the previous path? I don"t have any idea how to do It.
Emhi
tmccormi wrote on Monday, April 09, 2012:
You would have to look into the backup files themselves. I assume you did a backup before you did the upgrade.
However the path is just going to be where ever mysqldump is installed inside your XAMMP install, probably
C:\ … (somepath) …\xampp\mysql\bin\mysqldump.exe …. or similar
-Tony
bradymiller wrote on Tuesday, April 10, 2012:
Hi,
Once you figure out the path, you can set it here:
Administrion->Globals->Miscellaneous->‘Path to MySQL Binaries’
BTW, the patch should not of altered this setting; were you able to use the backup mechanism previous to the patch?
-brady
OpenEMR
emhi wrote on Tuesday, April 10, 2012:
Thank you Brady and Tony I went to globals and I fixed. I changed to C:\xampp\mysql\bin
.I think this happened because I moved Openemr from ubuntu to xampp because I was having problems to upgrade the patches In the ubuntu server
I have another error message too and I don’t know the reason:
Reminders
ERROR: query failed: SELECT dr.pid, dr.dr_id, dr.dr_message_text,dr.dr_message_due_date, u.fname ffname, u.mname fmname, u.lname flname FROM `dated_reminders` dr JOIN `users` u ON dr.dr_from_ID = u.id JOIN `dated_reminders_link` drl ON dr.dr_id = drl.dr_id WHERE drl.to_id = ? AND dr.`message_processed` = 0 AND dr.`dr_message_due_date` < ADDDATE(NOW(), INTERVAL 5 DAY) ORDER BY `dr_message_due_date` ASC , `message_priority` ASC LIMIT 0,5
Any suggestion on this
Thanks again
Emhi
Error: Table ‘openemr.dated_reminders’ doesn’t exist
bradymiller wrote on Wednesday, April 11, 2012:
Hi,
It sounds like you aren’t running the sql_patch.php script, which is step 3 of the patch instructions: http://www.open-emr.org/wiki/index.php/OpenEMR_Patches#Windows
-brady
OpenEMR
emhi wrote on Wednesday, April 11, 2012:
Thank you very much Brady.
I ran for second time the patch and it took care of the error.
I am new with this great great EMR from the open source community.
Thanks again