Back up error with XAMPP

diamondgr wrote on Tuesday, June 29, 2010:

I used the HOW TO installation you see here. Althought it’s in Greek, I hope you understand how I installed it.

When I try to backup the database from the program, I get the message:

"/usr/bin/mysqldump -u 'openemr' -p'greeklug' --opt --quote-names -r /tmp/openemr_web_backup/emr_backup/openemr.sql 'openemr'" returned 127: 

What can I do?
Thanks

tmccormi wrote on Tuesday, June 29, 2010:

The path being called is the unix path.  You are using a windows installation.  You need to edit the globals.php to point to the correct path of your mysql (and other tools) for this to work on windows.

on XAMPP, assuming you installed it on the C:  the path would be c:\XAMPP\bin\mysqldump, if XAMPP is added to the Windows PATH environment variable you can skip the pathing and just use the binary name.

The temp needs to be configured as well.  

Hope that gets you pointed in the right direction.
-Tony

diamondgr wrote on Wednesday, June 30, 2010:

As you probably saw I installed it on Linux (Fedora and openSUSE).
I changed the path of the globals.php:

from:
webserver_root ="/var/www/openemr";  
to
$webserver_root = "/opt/lampp/htdocs/openemr";
and from
$web_root 
to 
$web_root = "/openemr";

Is there a record called backup?

visolveemr wrote on Thursday, July 01, 2010:

Hi

The mysql error 127 says that the table(s) might be corrupted.  Just try checktable/Repairtable from the phpmyadmin itself.  If the table is corrupted, the status will be shown and you can do Repair table.

The backup process need only the /tmp access by default and nothing to do with globals, if the application is running properly.

Thanks
vicareplus Team
www.vicareplus.com