How to migrate your database from one computer to another with openEmr 7.0.1

i installed openERM on a new PC but still wanted to use the patient data and other information on the old database on the old PC. but any time i use the import data i get errors and i don’t want to take the long way of having to copy each table information to insert into the new database. please can anyone help me get all my data from the old PC to the new one?

Follow the steps described in any of the options displayed here. If you run into problems, post your steps and specific errors for community to help.

what’s your OS and server config?

To answer this I need the following information:

Which version are you dumping from and which version are you loading to?

What errors are you getting?

If you are using versions 502 or above, you will run into key issues.

You should be able to do a mysqldump on the source computer. Then rsync the sql file into the targete computer. Using mysql CLI you can import the table into a database.

If you are working with different versions you may need too run the upgrade script. Depending on the version you will need to remove the keys located in the sites/defau;t/logs_and_misc/methods/sixa and sixb.

windows 10 and wampserver 3.3.0

which version of OpenEMR?

Since i don’t know your version of Openemr and the size of your database, try in demo environment and then check if everything is working. And i have to declare i don’t know what Iam talking about :grinning:

1- Just use the Admin>System>Backup>Create backup. Wait till it finishes and sends file to download. This is the database SQL file. Or MySQL Workbench for WampServer.

Now you need to stop all Wamp services and close it in task manager.

2- Backup your existing OpenEMR installation:

  • Locate the OpenEMR project folder on your current PC. By default, it’s installed in C:\wamp64\www\openemr.
  • Make a copy of the entire OpenEMR project folder to a safe location as a backup.
  • Make sure you know the default root password you used first time when creating
    your database because, you will need it.

3- Install WampServer on the new PC:

  • Download and install the same version of WampServer on the new Windows 10 PC on the same hard drive.
  • Ensure that Apache and MySQL services are running.

4- Transfer the OpenEMR project folder:

  • Copy the OpenEMR project folder from your old PC to the appropriate location on the new PC C:\wamp64\www\.

5- Import the OpenEMR database:

  • Access the database management tool (MySQL Workbench) on the new PC.
  • Create a new, empty database for OpenEMR.
  • Import the SQL file that you exported from the old PC’s database into the newly created database on the new PC. (ENSURE YOU IMPORTED ALL TABLES AND NO ERRORS AFTER FINISHING IMPORTING)

6- Update OpenEMR configuration files:

  • Navigate to the OpenEMR project folder on the new PC (the one you copied to www).
  • Look for the sites directory and locate the site_id folder. Inside this folder, you’ll find the database.php file.
  • Open database.php with a text editor and update the database-related configurations (database name, username, password) to match the new database you created in step 5.

7- Start Apache and MySQL:

  • Open WampServer control panel on the new PC.
  • Start the Apache and MySQL services.

8- Access OpenEMR on the new PC:

  • Open a web browser and enter http://localhost/openemr in the address bar, or
    your previous customized link.
  • You should see the login page for your OpenEMR installation.

9- Test the transferred system:

  • Log in to your OpenEMR system on the new PC using the same credentials as on the old PC.
  • Verify that all your medical records and settings are intact and working as expected.

Always take care to back up your data and verify the steps, as any mistakes could lead to data loss or system issues. If you encounter any problems, consult pros around here, me excluded :sweat_smile:

1 Like

There is a lot easier way of doing this.

Please read from my previous post Update/restore - #7 by jhunyan

For Windows I follow these steps to move Open EMR from one PC to another.

1 - Make new installation of Open EMR (same version as previous)
2 - Copy and replace following folders from old to new PC - C:\xampp\mysql\data and C:\xampp\htdocs\openemr

This works every time



i shall try this one. Thank you.