lms and erp problem

hadiseh · 01-17-2006, 08:56 AM

hi
i have erp and lms on my system together.lms uses mysql 3 and erp uses mysql 5.these two version cann't work together.when ever i want to run erp i have to stop mysql 3 and run mysql 5 and ...
how can i solve this prob?how can i change my mysql 3 without losing my data?
plz help me

jimvin · 01-17-2006, 10:03 AM

Hi,
It sounds like the best option would be to migrate your data from the MySQL 3 database to the MySQL 5 one. I am not sure if both apps support version 5.

On the other hand, you probably can't run both at the same time since they are trying to open the same TCP port or socket file. If you reconfigure one to listen on a different port (or a different IP address if the server is multi-homed) you may be able to run them at the same time.

Regards,
Jim

hadiseh · 01-18-2006, 01:20 AM

hi jim
thx for reply.can u explain me how can i reconfigure one of them to listen on a different port?
thx

jimvin · 01-18-2006, 04:40 AM

Check out the MySQL manual...

http://dev.mysql.com/doc/refman/5.0/...e-servers.html

Regards,
Jim

hadiseh · 01-22-2006, 04:07 AM

hi jim
thx a lot.u solve my problem.thx thx thx