View Single Post
  #8  
Old 22nd September 2006, 05:20
lifeisboost lifeisboost is offline
Senior Member
 
Join Date: Feb 2006
Posts: 122
Thanks: 0
Thanked 2 Times in 2 Posts
Default

sorry to bring an old thread back BUT im trying to replicate 7 DB's i tried entering each DB into my.cnf but when i go to show master it shows all the dbs being logged into one bin log is this correct?

+------------------+----------+-------------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+-------------------+------------------+
| mysql-bin.000002 | 1125758 | web1_db1,web1_db2 | |
+------------------+----------+-------------------+------------------+

should there not be a binlog for EACH db? or does each position make up for it being different db's? also i see everytime you restart mysql it creates another log file. if i tell the slave to watch mysql-bin.000002 and the master gets rebooted it will rotate to log mysql-bin.000003, would i then have to set everything back up on the slave?

Last edited by lifeisboost; 22nd September 2006 at 18:36.
Reply With Quote