this is what i did in restoring:
i unziped the .tar backup file which gave me 3 other files.
1.openemr.tar file 2. the openemr.sql file 3. phpgacl.tar
i unzipped openemr.tar and copy it to the existing xampp/htdocs/openemr folder and i also unzipped the openemr.sql and i deleted the existing openemr database, created a fresh openemr and imported it.
but when i tried accessing the openemr through localhost/openemr it gave me the error above.
i am using windows7, xampp 1.81 and openemr 4.1.2(4)
@fsgl, thanks for your help. the first option you gave, i dont know how to go about. Please can u be more explicit,thanks.
As regards the 2nd suggestion,that will be good for a fresh copy of backup but i will need the 1st option to restore back. Pls help
If the old xampp folder has not been deleted & you are restoring to the same machine, rename it oldxampp.
Extract the openemr.sql file if it has the .gz extension at the end of the file name.
Go to Windows Explorer, copy & paste the .sql file to C drive. It should be the last item in the list of folders.
The command line in Windows is called Command Prompt, 2 ways to open it.
At the flashing cursor, type the following & hit Enter:
CD C:\
When the flashing cursor appears again, type this, (no space between p & root_password) & hit Enter:
C:\mysql -u root -proot_password openemr < openemr.sql
If you don’t remember the mysql root_password, it should be in C:\xampp\security\security\mysqlrootpassword.txt.
I tried your above suggestion, I even cut and pasted your command above and got this error: C:\mysql is not recognized as an internal or external command, operable program or batch file.
I don’t mind deleting and staring over but I have a couple of questions.
Does the version of mysql database make a difference when trying to transfer the data to the new computer. My Linux machine is over 3 years old, so the versions of MySQL are 3 years old also.
My openemr.sql file is 672,535 KB in size (665MB). Is this too big? I have over 3 years of data. The php.ini default of upload_max_filesize = 30M seems small.