Can someone please guide me to the instructions to import the database (everything I need from the old to the new) I am presently using from my older Linux server?
Can someone please guide me to the instruction to set up this computer as the web server once all data is in place?
[21-Dec-2014 19:11:51 America/Chicago] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 41602048 bytes) in C:\xampp\phpMyAdmin\libraries\Error.class.php on line 172
1. When logging into phpmyadmin, the user name should be root not admin and you will need the adminstrators password. You can log into phpmyadmin with user "admin" without a password but you will not have access to what you need.
2. When choosing the database you wish to import into, you have to click on the word, openemr, not the circle next to the word, openemr. Clicking on the circle does not choose the database.
I solved the memory problem by adding: $cfg[‘UploadDir’] = ‘c:\xampp\tmp’; to the config.inc.php file. I put the openemr.sql file in c:\xampp\tmp and it uploaded it.
I increased the memory in the php.ini file as you suggested above to 999M, but it still did not work, so I tried the other route.
I think I got it uploaded since there were no error messages but openemr would not open giving me the following error message:
ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=? AND constant_name = ? LIMIT 1
Error: Table ‘openemr.lang_definitions’ doesn’t exist
This error was in php_error_log:
[21-Dec-2014 19:11:51 America/Chicago] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 41602048 bytes) in C:\xampp\phpMyAdmin\libraries\Error.class.php on line 172
Will increasing the memory in the php.ini file to 999M cause any problems?
First you may need to check the number of tables in openEMR. There may be possibility that, the table(lang_definitions) is missing. For your information the total number of tables in 4.1.2(Patch 7) should be 169.
Try running the following commands, to check for correct privliges:
C:> cd “C:\Program Files\MySQL\MySQL Server 5.0”
C:> bin\mysql -u root -p mysql
mysql> SOURCE share/mysql_fix_privilege_tables.sql
After this restart the mysql service.
Ensure that the php version installed in new windows server is same as version installed in the older linux machine
Need to ensure the php.ini requirement are correct for openEMR 4.1.2 according to this link
If none of the solutions works, try reinstalling the whole setup including the XAMPP package and OpenEMR.
Thank you and fsgl for your continuing input while I solve this issue.
There were only 63 tables in my openemr database - A-F.
I ran the 2 commands as you mentioned above and got an “access denied” response to them both.
The MySQL version on my Linux machine is version 5.1.58. The recent install on my Windows computer is Server version: 5.5.32.
php.ini requirements were the same except for the file size limits that I increased to 512M.
Can you see any problems I am facing and and work arounds to these issues?
By the way, my openemrsql file is 672,535 KB in size (665MB). Would I increase the upload max filesize to greater than this number? So far we have been discussing 512M, but is that enough if I’m working with a 665MB file?
You have only 63 tables in your database. It seems, the upload of the database was not completed successfully.
Try restoring your openemr.sql file using command prompt. You can follow either of the below steps: (This will not consider the memory limit). Drop your database and create it newly before doing these steps.
a. In Your XAMPP Control Panel click the “SHELL” button, which will take you to the console.
Here run the following command to import your backup database. (Provided you should know your mysql username and password)
mysql -u {username} -p {databasename} < {exact path to openemr.sql file}
[OR]
b. Open Windows Command prompt.
Here run the following commands (Provided you should know your mysql username and password)
cd C:\xampp\mysql\bin
mysql -u {username} -p {databasename} < {exact path to openemr.sql file}
Both (a & b) methods will import your database correctly.
Also try checking your Older OpenEMR version, the number of tables it have and also check whether the export of its database was done properly.