Recovering lost access & data

Day-to-Day Users
1

lodell wrote on Tuesday, December 29, 2015:

I migrated to Office Ally a # of years ago but maintained the OEMR for historyical records. When My hard drive crashed, I had one rebuilt but my equipment person does not know how to open the files for me to access on thios new drive. He wrote:
*Used thefollowing command with the old SQL file:

3. Import the old database via Command Prompt with the dumpfile in C-drive into the new database with these 2 commands:

CD C:
C:\xampp\mysql\bin\mysql -u root -p openemr < openemr.sql

What do we do now?
Please reply to chhhc@centralny.twcbc.com, too if you can.

2

cmswest wrote on Tuesday, December 29, 2015:

hi Lynne, it sounds like you succeeded at reinstalling the database with that command

you could perform queries on the tables but in order to use openemr to access the data you’d want to reinstall the appropriate version which would be in the table named version

older windows xampp package downloads:

https://sourceforge.net/projects/openemr/files/OpenEMR%20Windows%20XAMPP%20Package/

3

fsgl wrote on Tuesday, December 29, 2015:

Hi Lynne,

Are you near Syracuse?

Did professional support do Step 2 of Importing Old Data?

Was Step 3 successful?

Fortunately you have Windows XAMPP; so MySql & OpenEMR login credentials are readily available, if you don’t have them written down.

4

lodell wrote on Wednesday, December 30, 2015:

Hello, fsgl. I just spoke with stephen Waite of VT who wrote to my e-mail. What the 2 of you have noted here might as well be Greek to me. If it is OK with you, I would like to have my off site IT guy reach you after he tries this. I would expect he wouldn’t be in touch until Jan 4th or later. chhhc@centralny.twcbc.com

5

lodell wrote on Wednesday, December 30, 2015:

yes, fgsl, I am in Syracuse, NY. Is this something you could help me with directly rather than going through my IT person? Note-I am a computer migrant and hate it! Have a bad case of fat finger syndrome.

6

fsgl wrote on Thursday, December 31, 2015:

It’s very difficult not to have dyspepsia after a hard drive crash.

We’ll do our best to walk you through this with a minimum of jargon.

First, are you able to login to OpenEMR on the rebuilt?

Second, did you save a backup of OpenEMR before the crash?

The solution to getting access to your files may be as simple as a few mouse clicks.

7

fsgl wrote on Thursday, December 31, 2015:

Hi Lynne,

Don’t despair. I think your IT support did not understand the last section of the above cited Wiki article.

It’s really not difficult. A sibling always reminds me that it’s not difficult if you know how.

O.K., put on your armor & let’s do battle.

A user can’t get into OpenEMR if the lights have not been “turned on”. Note that each step has been accompanied by an attached image below, which had been numbered in order of viewing. It’s nearly impossible to get the images to display in the intended order. There is no 2b.png.

  1. Go to your Start menu.
  2. Type the letter, W, into the search bar & Windows Explorer will pop up above the search bar. Double click it. You’ve seen Windows Explorer before. Perhaps you did not know previously what it was called. Direct your attention to the left side bar & double click C-drive.
  3. Double click xampp & scroll down to the bottom.
  4. Double click xampp-control.
  5. Click the first Start button, wait 30 seconds, then click the second Start button.
  6. Look for the messages below the console. The lights have been “turned on”. Click Quit to exit xampp-control.

Assuming that IT support put everything back into the rebuilt, you should be able to login now to OpenEMR.

If you can’t login, ask IT support to post in this thread.