[Cialug] mysql replication

[Dave Weis]

Has anyone gotten it working? I think I have it set up correctly but the 
master shows:
mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000002 |   203328 |              |                  |
+------------------+----------+--------------+------------------+
but all of the examples I've seen show something in the Binlog_Do_DB 
column. I have the following lines in the my.cnf
log-bin = mysql-bin
server-id = 1
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:2000M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
innodb_buffer_pool_size = 768M
innodb_additional_mem_pool_size = 128M
innodb_log_file_size = 512M
innodb_log_buffer_size = 256M
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
innodb_safe_binlog = 1

The files are innodb format.

Thanks
dvae



-- 
Dave Weis
djweis at internetsolver.com
http://www.internetsolver.com/