We have OpenEMR 4.1.0 on Ubuntu 14.04 LTS server and are trying to move the data to a new server with Ubuntu 16.04 LTS with OpenEMR 5.0.0 sucessfully installed. We have tried the backup and restore script method on the wiki without success. We created a backup using the tool on the 4.1.0 machine then transferred the emr_backup.tar and restore script to the 5.0.0 server and tried to run the restore script after moving the openemr folder without success.
I know the emr_backup.tar has the openemr folder site and sql database file. Is there a way to do it manually by replacing the openemr folder and updating the sql database with the files in the emr_backup.tar.
I can move the openemr folder but need help with the steps to replace the sql database file. Can someone explain the steps with phpmyadmin perhaps.
If this is not possible we are also okay with installing 4.1.0 on the Ubuntu 16.04 LTS server as well and running the restore script but the 4.1.0 deb package installer does not work on 16.04 LTS maybe because of php 7.0