Upgrade Advice -

aemandler wrote on Tuesday, April 08, 2014:

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.

sunsetsystems wrote on Tuesday, April 08, 2014:

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!

Rod
http://www.sunsetsystems.com/

yehster wrote on Tuesday, April 08, 2014:

The sequence I suggest is.

  1. Install clean copy of 4.1.2 on new server. Test and verify it is functioning correctly.
  2. mysqldump the 4.1.1 openemr database from old server, copy and re-import on new server
  3. copy contents of sites directory from 4.1.1 server to sites directory on 4.1.2 server
  4. Run the sql_upgrade.php script on the 4.1.2 server
  5. Test the new system with your old data

aemandler wrote on Tuesday, April 08, 2014:

Thanks, Rod. Backup and restore working fine on the old server.

aemandler wrote on Tuesday, April 08, 2014:

If this will work, seems easier than installing 4.1.1, then doing 4.1.2 install and upgrade. I’ll try it and report back. Many thanks.

fsgl wrote on Wednesday, April 09, 2014:

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:

  1. Backup 4.1.1 using built-in utility on old server.
  2. Upgrade 4.1.1 to 4.1.2 on old server.
  3. Backup 4.1.2 on old server.
  4. Install 12.04 LTS on new server (supported until 4/2017).
  5. Install Brady’s 4.1.2 package on new server.
  6. Restore 4.1.2 backup in new server as explained here.

aemandler wrote on Thursday, April 10, 2014:

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.

aemandler wrote on Thursday, April 10, 2014:

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.

fsgl wrote on Thursday, April 10, 2014:

Hi Art,

Nice to hear that Kevin’s advice worked.

Some Linux users had difficulty upgrading because of the difference in versions of php, so it makes sense.

Good to have your followup post so that others can avoid the frustration as they migrate between servers.

blankev wrote on Friday, April 11, 2014:

fsgl,

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.

??? Or we could wait for our new BS.

fsgl wrote on Friday, April 11, 2014:

Hi Pimm,

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.

blankev wrote on Friday, April 11, 2014:

“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?

fsgl wrote on Friday, April 11, 2014:

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.

Peppy was created on Windows XP.