I have limited server knowledge, but we have IT guy- so I may not understand all the language, but with insructions I can pass it along! We’re divorcing our old IT guy and he may hold our server hostage. We may need to buy a new server and I need to know how to transfer OEMR/data to the new server (i.e. pt demos, encounters, superbill info, practice info etc), basically all the info. If we can transfer OpenEMR as a whole, great. But if we should just install a new version and upload the pt database into it, that’ll be fine. I’d rather avoid filling in superbill, address book, all the admin stuff etc- but can if we have to. Or would that all come over somehow?
If someone has an answer I can understand, great, but if answer is unavoidably over-my-head-techno, that’s ok. I’m hoping we’d just install a new emr on new server and download/upload a full backup (from existing emr) into new one… (right)?
BTW, when I go to Database link under Admin I get ‘you do not have access to this resource’, but the owner/MD does (unfortunately he knows less about computers than I do so….). When I go to Backup under admin, I can make it backup, but there are no options for destination etc.
Thank You thank you thank you if someone can help, or at least get me started in the right direction.
There is a restore script for Linux, but for Windows it must be done manually. Perhaps a more Windows-oriented developer could chime in and explain the procedure.
This following thread has been very helpful to me in restoring the database from the linux VM to the XAMPP 3.2 on server2k3. https://sourceforge.net/projects/openemr/forums/forum/202505/topic/3549521
The only issue I am finding and I’m sure there is a solution is the HTTPS can only be called up from localhost. Port 80 (http) has no problem on other computers on the internal network. I’m guessing it is an IIS issues, but I have not found the problem yet.
Good luck.
More to the point, you “IT guy” cannot, by law, hold any healthcare data such as that stored in OpenEMR “hostage” as you mentioned.
They are compleled to provide complete and total usable backups to you - and SHOULD be compleled to make the transition smooth with no downtime for you, but that last part is just a moral directive… not a legal one.
Tom
If it is the Windows Xampp version I just copy the xampp folder to the new computer( copying the folder AFTER using xampp-control.exe to shut down all the services…cause it won’t copy otherwise, then copy to c:\ on the new drive so it winds up in the correct default path) , and run xampp-control.exe, start the service, and log onto localhost/openemr.
It seems to be that simple.
I may have previously installed openemr onto the laptop, then deleted the xampp directory leaving behind some registry entries or something that is letting all this work, but someone more in the know can answer that more effectively. I think you can just go for it. I do this CONSTANTLY so I can screw around with the database while not endangering the “real” one.
Thank You for the replies. Our new IT guy figured it out quite easily, just before aethelwulffe’s reply. And did exactly what he suggested! So we beat ya to it, but thanks for the reply and yes, that’s the easiest- and maybe only way.
Yes, illegal for our old IT guy to hold emr hostage, which it looks like won’t be a problem but just because somebody shouldn’t or ‘cant’ do something, doesn’t mean they won’t!
Dude! Congrats!
Proud to have found the easy answer, and prouder yet that you guys got it on your own.
Openemr sure is a good choice; It lends itself to heavy modification/specialization, comes with plenty of unspecializeds utility for your work flow, and has plenty of great people involved. I guess your recent happy resolution of this problem really kinda makes you wanna click that paypal donate button, hunh?
I’m glad I started recommending and installing this package for folks.
The xampp package is so darn easy to get going, and anything you need to learn to get it going is well worth knowing. I find that too many medical professionals are not very well educated (lacking any knowledge outside the scope of medicine), and when they become a business owner they must depend heavily on others. Most often, this makes them paranoid due to lack of understanding, and they often gum up their own works. Running a business is hard, and you are SUPPOSED to be self serving. You have got to delegate some very important duties (like day-to-day IT) but you also gotta be involved. I hope this little incident has given you some more knowledge and confidence in this system, and the fact that OpenEMR comes with a huge gang of smart helpful friends.
Sorry to join the party late!
i have just installed open emr 3.2 and i’ve been using 3.0 on my old macbook pro.
how do i move my data from 3.0 to 3.2?
i have 2 machines now with different versions of open emr. i use MAC OS X
i also cant figure out where the back up is stored!
please help
Hmm… I am a Windows type. I don’t know much about OS X.
I do recall that I upgraded from2.8 then to 3.0 thento 3.1 and finally to 3.2.
I have never been able to find a backup either. That led me to just copying the openemr directory and the mysql/data directories for my “Backup”.
For the upgrades in OSX, we are lacking wiki documentation,but I doubt it is all that hard.
If you are putting it back in the same directory as a previous version, you basically copy some files from a stored copy of the old one onto the new one that is in the original location, then run sql_upgrade.php and acl_upgrade.php to change the databases.
am at my wits end! i followed the instructions to the letter until i got to the sql upgrade. this is what i got
Warning: opendir(/var/www/openemr/sql) : failed to open dir: No such file or directory in /Applications/XAMPP/xamppfiles/htdocs/openemr/sql_upgrade.php on line 149
Cannot read /var/www/openemr/sql
i even allowed all permissions on the upgrade file but no joy!
now i have done a fresh install on a second machine. im trying to import into it the database from the old machine using the same instructions as above. fingers crossed
Unfortunately I cannot assist you with the XAMPP installation. If you were trying to install the package as a “native mode” application under the Mac OS I could point you in the right direction.
Someone with XAMPP experience might be able to help.
nthurman thank you very much! this forum didnt post my last message!
i succeeded in moving my database, it was quite simple ( speaking in retrospect!!!)
i started a new installation of xampp and openemr 3.2 on a secon machine that has not run emr.
then copied these folders;
documents
edi
era
letter_templates
from old emr 3.0.0.1 and replaced them in the new emr 3.2
then copied entire var folder from the old xampp and replaced the new one
then ran the sql_upgrade and acl_upgrade on the new file and hey presto! all my data is preserved!
thank you for all the support guys!
i hope my narrative is clear enough to help someone else in the same predicament.!!
