Helping someone who is currently running 4.1.1 on OLD Ubuntu (8.04). Plan to upgrade to 4.1.2 and move to new server at same time. Old server will not do upgrade to 4.1.2 probably because of old OS. What is the best practice here? Do I install 4.1.1 on the new server, backup and restore the data, then do the upgrade on the new server? Or is there a way to install 4.1.2 on the new server and move the 4.1.1 data to it? Thank you.
What I do is copy the old installation to the new server and make sure it still works. Then upgrade it.
To do the copy, you can either do a normal backup and restore it using the restore script, or if it’s too big for that then do the equivalent manually.
By the way if you don’t have working procedures to back up and restore then you have problems more important than upgrading!
The premise that 4.1.1 cannot be upgraded on the old server may not be accurate. The upgrade webpage suggests that leapfrogging from version 3.0.1 is possible, therefore going from 4.1.1 to 4.1.2 should also be possible.
Unfortunately, Ubuntu leapfrogging is not possible as noted in their upgrade webpage. If 8.04 is not LTS, it may be a 9 step process.
Had Ubuntu leapfrogging been possible, then it would be a simple matter of creating a system image with Clonezilla and transfering the whole kit and kaboodle to the new server.
A slight wrinkle to Rod’s suggestion:
Backup 4.1.1 using built-in utility on old server.
Upgrade 4.1.1 to 4.1.2 on old server.
Backup 4.1.2 on old server.
Install 12.04 LTS on new server (supported until 4/2017).
Hey Kevin – Thank you. I followed your instructions and was successful. Did a mysqldump on the old server, then deleted the openemr database on the new server, imported the mysqldump file, and followed the instructions in the OpenEMR Upgrade Manual here: http://www.open-emr.org/wiki/index.php/Linux_Upgrade_4.1.1_to_4.1.2
to complete the process. Worked just great.
fsgl – The sql_upgrade.php script failed on the old server. I spent a little time troubleshooting it, but eventually felt it wasn’t worth the trouble to diagnose. See my response to Kevin above for how I successfully did the combination data transfer and upgrade. Thanks.
can you ahve an attempt to integrate this advise in the WIKI pages? With the end of WinXP this seems to have more importance than the usual changes of hardware.
I thought that I would write the Wiki article after I had mastered the command line. Still not as familar with the folder architecture in Linux as I am in Windows.
Sure, I can get it started and refine it as we go along. When Harley is done with his course work, I’ll ask his help with the technical stuff.
“Mint”, the Click and go solution for those who dare to do something different. I like the automatic updates and want to install Ubuntu OpenEMR version, but I am still learning to use the left button on the tablet pointing device and not being surprised to the nothing happen adventure with the common double click.
What was on your mind (MINT) when introducing Pepper for donations?
Had bad luck with Ubuntu, so will stick with Linux Mint for the Wiki article.
Verdant green is preferred over orange/purple. Trivial matter, but if a user has to look at the graphics everyday; it might as well be pleasant. It’s a bear customizing Ubuntu.