"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:
> 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