List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:November 11 2003 2:58pm
Subject:Re: offline replication with binlogs
View as plain text  
"Mauro Marcellino" <mmarcellino@stripped> wrote:
> 
> Hello again...
> 
> I am transferring binlogs between two networks that are not connected as an offline
> replication solution.  I have two databases which I have configured the my.ini file to
> create binlog entries for.  
> 
> Do both databases get written to the same log or is there a separate log for each
> database.  If both are written to the same log how do you use the mysqlbinlog command to
> update both databases?  Do you just run it twice like this?...

Queries will be written to the same log. If you look at the output of mysqlbinlog you can
see USE database_name commands that change current database. So you need execute
mysqlbinlog just once:
	http://www.mysql.com/doc/en/mysqlbinlog.html
> 
> 
> mysqlbinlog binlog_name > db1
> 
> mysqlbinlog binlog_name > db2



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
offline replication with binlogsMauro Marcellino10 Nov
  • Re: offline replication with binlogsEgor Egorov11 Nov