I am trying to configure a MySQL server to run multiple instances of the daemon (I wish to duplicate it onto different drives). I've been trying to use the mysqld_multi script. However the script is not finding the groups in /etc/mysql/my.cnf.I copied and pasted the the configuration from msqld_multi --example into my.cnf, and this discovered the groups fines. However when I tried to modify the file below mysqld_multi report just displays: Reporting MySQL serversNo groups to be reported (check your GNRs)Below is an abbreviation of my my.cnf file.[mysqld_safe]socket          = /var/run/mysqld/mysqld.socknice            = 0[mysqld1] #this is for the master serverpid-file =/var/run/mysqld/mysqld.pidsocket =/var/run/mysqld/mysqld.sockport =3306datadir=/var/lib/mysqlserver-id=1log-bin=mysql-bin[mysqld2] #for the slave!pid-file =/var/run/mysqld-slave/mysqld-slave.pidsocket =/var/run/mysqld-slave/mysqld-slave.sockport =3307datadir =/var/lib/mysql-backupserver-id=2skip-innodbdefault-storage-engine =myisam[mysqld_multi]user            = mysql[mysqld] basedir         = /usrtmpdir          = /tmp...Here's a short bit from mysqld_multi --example[mysqld_multi]mysqld     = /usr/bin/mysqld_safemysqladmin = /usr/bin/mysqladminuser       = multi_adminpassword   = my_password[mysqld2]socket     = /tmp/mysql.sock2port       = 3307...Can anyone spot why mysqld_multi isn't parsing this?
Mysqld_multi doesn't recognize groups
mysql;etc
I found out the problem. Mysqld_multi can't parse comments at all, so you just need to remove all the comment lines with # before them from my.cnf.