Backup probs

Management and Administration
1

stevenlong wrote on Sunday, November 27, 2011:

Hi, On trying to backup OpenEMR ( 4.1.0 (2) ) I get the following message: “K:/Servers/wamp/bin/mysql/mysql5.1.36/mysql/bin\mysqldump -u “openemr” -p"password201” -opt -quote-names -r C:/windows/temp/openemr_web_backup/emr_backup/openemr.sql “openemr”" returned 1:
I am using Windows Vista and Wamp, php 5.2.0 with OpenEMR on a portable hard drive ‘K’. C:/windows/temp/openemr does exist, but is empty. I have installed Pear & package Archive_Tar ver 1.3.8, nothing on php error log ?

2

bradymiller wrote on Wednesday, November 30, 2011:

Hi,
I think bug has been reported previously on Windows. Would be interested to know what is getting reported in your php error log.
thanks,
-brady

3

tmccormi wrote on Wednesday, November 30, 2011:

Try running the command exactly as reported from the CMD window and see what the actual error reported says, that may help.

K:/Servers/wamp/bin/mysql/mysql5.1.36/mysql/bin\mysqldump -u "openemr" -p"password201" --opt --quote-names -r C:/windows/temp/openemr_web_backup/emr_backup/openemr.sql "openemr"

-Tony

4

tmccormi wrote on Wednesday, November 30, 2011:

Note:  you may have to flip the slashes around for it to work from the CMD window unless you have Cygwin or similar unix like shell tools installed.
-Tony

5

stevenlong wrote on Wednesday, November 30, 2011:

Thanks
from the command I realised I had a extra “mysql” in the command line. However,I get the same message K:/Servers/wamp/bin/mysql/mysql5.1.36/mysql/bin\mysqldump -u “openemr” -p"password201" -opt -quote-names -r C:/windows/temp/openemr_web_backup/emr_backup/openemr.sql “openemr”" returned 3: being the difference from returned 1. The file created is now much larger but obviously not all of it- any ideas?
thanks

6

yehster wrote on Wednesday, November 30, 2011:

I’m guessing the double quotes might be the problem.  Start simpler. From the command line
do k:
then cd into servers\wamp\bin\mysql\mysql5.1.36\bin
try

mysqldump -u openemr -p openemr

It will prompt you for the password at this point.
It will spew the data out to the console. -opt and -quote-names are actually the defaults (refer to mysqldump -help for more info).
You might be able to get a better look at a specific error message this way. 

7

stevenlong wrote on Saturday, December 03, 2011:

I found the fault using Command Prompt by entering mysqldump -u openemr -p openemr Fault was table “Log” which was repaired using phpMyAdmin.Everything works fine now. Thanks for all contributions.