sinmu wrote on Thursday, January 21, 2010:
I am using window xp for openemr, beside using pear for tar/achive module, Can I actually export the openemr database (sql) from the phpmyadmin and all its document folder and copy over to a new installation of openemr. I have tried this, but I am only able to recover the patient name field not all the fields in the database table, and also the document pdf.file are not in the correct path even after I copy over. Any idea?
bradymiller wrote on Saturday, January 23, 2010:
hey,
Backup overview (quick):
Need to backup two things:
1) Mysql database
Look up the mysqldump command (this will dump your database to a file), and then the mysql command can be used to re-create the database from the file.
2) Web directory
Easiest just to back up entire openemr directory
Joe may also weigh in with his method specific for windows, which will also suffice.
As an aside this is what the tar/archive method does. It is good not to rely on the tar/archive, becuase after your backup becomes too large it may not work.
-brady
-brady
sinmu wrote on Saturday, January 23, 2010:
thanks brady, really appreciate your help about the backup in windows that don’t rely on the administration backup tool
I still need to clarify with you that when we try to recover from backup in a new openemr installation, what is the correct way to recover, does it mean all we have to do is copy all our previous backup openemr directories to the new directory and import the sql file into openemr by using its build in phpmyadmin import. Will this recover all the appointment and customer data including the document attachment? Please advise.
thank you
sinmu
bradymiller wrote on Sunday, January 24, 2010:
Sinmu,
To restore (everything will be included):
-use mysql command on your sql dumpfile (made from mysqldump) to create the openemr database
-copy the backed up openemr directory into the new directory
-edit openemr/interface/globals.php and ensure webserver_root and web_root paths are set correctly
-edit openemr/library/sqlconf.php and ensure the mysql database entries are set correctly
-brady
bradymiller wrote on Sunday, January 24, 2010:
hey,
What version OpenEMR you using? This may change above restore instruction a little bit.
-brady
sinmu wrote on Sunday, January 24, 2010:
I am using the openemr 3.1 with patches 5, I will try what you have told and inform you the result so that others can follow this if they want. thank you
sinmu