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]