Re: Replication between different database names

2004-04-02 Thread Victoria Reznichenko
Andy Ford <[EMAIL PROTECTED]> wrote: > I guess what I'm trying to ask is . > is it possible for a MySQL server to be a slave to many MySQL masters? > One slave can have only one master. But you can run multiple instances of MySQL on the slave. -- For technical support contracts, goto h

Re: Replication between different database names

2004-04-02 Thread Andy Ford
I guess what I'm trying to ask is . is it possible for a MySQL server to be a slave to many MySQL masters? And can all of this information go into one my.cnf file so on startup the masters will all start syncing their data to the one slave Thanks Andy On Fri, 2004-04-02 at 12:49,

Re: Replication between different database names

2004-04-02 Thread Andy Ford
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, re

Re: Replication between different database names

2004-04-02 Thread Jonas Lindén
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

Replication between different database names

2004-04-02 Thread Andy Ford
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 = cu