From: Dan Nelson
Date: October 13 2008 8:08pm
Subject: Re: replication question -different db name on slave server
List-Archive: http://lists.mysql.com/mysql/214855
Message-Id: <20081013200839.GD99270@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 13), AM Corona said:
> In mysql 4, can one replicate a database to another server but have the DB
> name on the slave server be different?
> 
> Master :  dbname1
> Slave:  dbname1
> AND
> Slave :  dbname2 (but contains data from db2name1)

So you want the same data in two different databases on the same slave,
or is the 2nd slave line a different server?  If it's a different
server, then it can be done:

http://dev.mysql.com/doc/refman/5.0/en/replication-options.html#option_mysqld_replicate-rewrite-db

-- 
	Dan Nelson
	dnelson@stripped