This post originated from an RSS feed registered with PHP Buzz
by Andrew Johnstone.
Original Post: MySQL Install multiple instances
Feed Title: Development, Analysis And Research
Feed URL: http://direct.netli.wordpress.com/
Feed Description: babblings!
MySQL Install multiple instances.
Create a folder called Conf with Instance.1.ini, Instance.2.ini, and Instance.3.ini.
The Port each are listening on should all differ, as well as having a different data directory.
I named these
C:\Program Files\MySQL\MySQL Server 5.0\MySQLData\Instance1
mysqld --install "Mysql-Instance-1" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\Conf\Instance.1.ini"
mysqld --install "Mysql-Instance-2" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\Conf\Instance.2.ini"
mysqld --install "Mysql-Instance-3" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\Conf\Instance.3.ini"
in the ini file [...]