"Mauro Marcellino" <[EMAIL PROTECTED]> 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
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
