I've no idea!! My apologies for the blank response.... I am rather new to replication and still trying to discover what I actually need to do.
I have managed to get two databases with the same name across two different servers replicating correctly. When I change the name on the slave however, replications seems to stop. Is the option .... --replicate-rewrite-db=from_name->to_name used as a mysqld startup option!? or can I use a command from within mysql or the my.cnf file to achieve the same thing!? Thanks for replying Andy On Fri, 2004-04-02 at 12:49, Jonas Lindén wrote: > Hello, Is this what you are lookin for? > > --replicate-rewrite-db=from_name->to_name > > Regards > /Jonas > > > > I have a central mysql server that is required to be a slave to many > > different master databases on my customer sites. > > > > Is it possible to replicate many masters to one slave where the masters > > have the same DB name?? > > > > i.e. do this ..... > > > > customer A central site > > DB = cust ---> replicate to -----> DB = cust_A > > > > customer B central site > > DB = cust ----> replicate to -----> DB = cust_B > > > > etc > > > > etc > > > > Thanks > > > > Andy > > -- > > > > perl -e 'print qq^;@) [###]^^qq^z\.MY{eLQ9^' > > in:control developer, Telindus, RG27 9HY > > DDI: +44 1256 709211, GSM: +44 7810 636652 > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- perl -e 'print qq^;@) [###]^^qq^z\.MY{eLQ9^' in:control developer, Telindus, RG27 9HY DDI: +44 1256 709211, GSM: +44 7810 636652 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]