Move patient data from linux to windows

rayaz wrote on Sunday, November 08, 2009:

Hi
I have a working openemr database running in ubuntu 9.04. I now want to shift this data to an openemer server on Windows 7. How do I do that?
Thanks
Rayaz

bradymiller wrote on Sunday, November 08, 2009:

hey,

Will depend somewhat on your version and whether you performed upgrades in the past.

Most straightforward way is to install the same version of OpenEMR in windows 7 with the same mysql database/username/password.

Then in ubuntu instance use the administration->backup tool and copy this file over to your windows 7 server and unpackage it to get at the mysql database backup file and the openemr webserver folder file.

Then using mysql command or phpmyadmin to run the backup script into the windows 7 openemr database (drop previous one firstĀ  to be safe)

Then replace your windows 7 openemer web folder with the backup up one from ubuntu (remember to configure $webserver_root and $web_root variables at top of interface/globals.php with what yu ahd i the previous windows 7 folder)

assumptions:
-no sql-ledger or external php-gacl installed (using embedded php-gacl)

Of course test it out on test server first and ensure it works.

-brady

rayaz wrote on Sunday, November 08, 2009:

Thanks for the quick response. On to it now!