openEMR Migration from Windows to Linux box

Management and Administration
#1

Hi,

I installed OpenEMR 5.0.1 on my linux hosting and moved my database from local computer which is windows based. it is successfully migrated and all functions are working properly but when I try to backup my database from linux box I got error

“C:/xampp/mysql/bin/mysqldump -u ‘openemr_saif’ -p’Pmr123456’ -h ‘localhost’ --port=‘3306’ --opt --quote-names -r /tmp/openemr_web_backup/emr_backup/openemr.sql ‘openemr_saif’” returned 127:

Let me know, what should I do

#2

Hi @saifurab ,

Rec changing settings at Administration->Globals->Miscellaneous
Path to MySQL Binaries: /usr/bin
Path to Perl Binaries: /usr/bin
Path to Temporary Files: /tmp
Path for Event Log Backup: /tmp

-brady

1 Like
#3

Thanks Brady,

This helpful but but when backup ends then I receive “Page not Found” error. I also receive the same error for “Create Event Log Backup”

“/usr/bin/mysqldump -u ‘openemr_saif’ -p’Pmr123456’ -h ‘localhost’ --port=‘3306’ --opt --quote-names -r /temp/emr_eventlog_backup/eventlog_20180507_051103.sql ‘openemr_saif’ --tables log_comment_encrypt_backup log_backup log_validator_backup” returned 1:

Thanks
Saif

#4

I have resolved the event log issue. since it is shared hosting, si I don’t have access to temp. so i changed it folder under my public_html folder

#5

Hi @saifurab ,

The backup feature in OpenEMR is limited by the memory_limit setting in your php.ini. What do you have set for that now?

-brady

#6

Hi Brady,

I am using Godady. I made some changes in it see my configurations in screenshot attached. but it didn’t resolve my issue

aa
aa925×597 90.4 KB

#7

any help regarding this issue!!

#8

Hi @saifurab ,

Sorry about the delay. What are you seeing in the PHP error log?

thanks,
-brady

#9

its hosted on godaddy and i am not able to see php error log. only i know that it starts backup and displays message “Dumping OpenEMR database…” and then page not found

pnf
pnf1567×728 108 KB