Unanswered: Novice in mysql..need help in having multiple instance of mysql under windows
Question might look very silly.
We have a product that uses mysql. Under Unix we had no problem of copying the whole directory structure of mysql as a part of our product installation directory and configure .my.cnf with proper port# and socket file. The whole product gets installed under a specific unix ID.
I am totally lost and confused under WIndows environment (98/2000/XP).
Assuming the client already has a mysql installed and his/her my.cnf is configured to point to the data and bin directory (basedir & datadir). When we install our product, i am not sure how do I handle the mysql installation and/or configuration of my.cnf file.
Is there a way I can define multiple datadir in the existing my.cnf and also different port#
Basically is it possible to have multiple mysql instances under windows.