List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 13 2008 8:08pm
Subject:Re: replication question -different db name on slave server
View as plain text  
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
Thread
replication question -different db name on slave serverAM Corona13 Oct
  • Re: replication question -different db name on slave serverRob Wultsch13 Oct
  • Re: replication question -different db name on slave serverDan Nelson13 Oct