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.

I hope i am clear

really appreciate your early response