bdwderm wrote on Tuesday, November 10, 2009:
Hi, I’m currently running 2.9.0 on PCLOS. I have become a fan of Ubuntu and plan to install Ubuntu server and the latest version of OEMR. Finally, import database from old version. Any thoughts on the best way to do this? Does the newer version have more / different database fields or will it all just “fit.”
Thanks in advance for your attention.
Brent
bradymiller wrote on Tuesday, November 10, 2009:
hey,
I’d suggest doing the ugprade first. Then can migrate it. Upgrade from sub-3.0 isn’t straightforward. The procedure depends on your answer to the following questions.
1) Do you have php-gacl installed?
2) Do you have sql-ledger installed?
3) Do you have a user called ‘admin’?
-brady
bdwderm wrote on Wednesday, November 11, 2009:
I believe its yes to all (I’ll check admin).
I don’t need sql-ledger ever though it is installed.
Brent
bradymiller wrote on Wednesday, November 11, 2009:
hey,
I’m also going to assume your php-gacl tables are in a separate database (ie, not in the openemr database)
Check out docs for a similar upgrade I did going from 2.8.3 to 3.0.1 (and from Mandriva to Ubuntu) here:
Follow steps 1-6 and use openemr 3.1.0 instead and with following exceptions in step 1:
—Do not modify openemr/gacl/gacl.ini.php
—Do not modify openemr/gacl/gacl.class.php
—Instead of copying the the openemr/library/sqlconf.php file from your old verion to new, you should modify the new one with the old settings and set $config to 1.
Then, I’d suggest trying the restore script in openemr/contrib/util/restore in order to install the backup (from step 6) into ubuntu (if that doesn’t work let me know, since it’s also straightforward to do manually)
Most importantly, back up your data and try this on a testing server first, since it may take a couple attempts before successful.
bradymiller wrote on Wednesday, November 11, 2009:
Another key point:
When you modify the openemr/interface/globals.php file during upgrade, ensure you set $webserver_root and $web_root to be same as your previous version.
bdwderm wrote on Thursday, November 12, 2009:
Thanks. I plan to do this before the end of the year and will post result!