Greetings, I am replicating from 4.0.17 to 4.0.16. I read through the replication docs, and I didn't see anything relating to what I'm trying.
What I am hoping to do ... is slave the multiple databases ( the whole thing ), in order to avoid shutting down ( or at least locking ) the master and making a copy/dump. When I tried, and did a show master status ... the message was "Writing to Net". I left it for several hours, but nothing at all was replicated that I saw, and the status never changed. My question the, is that is this possible to do a full replication without a dump of some sort ? My replication config on the slave side is: [mysqld] server-id=15 master-host=master master-user=repuser master-password=pass replicate-do-db = db1 replicate-do-db = db2 replicate-do-db = db3 And on the master the following: [mysqld] server-id = 11 log-bin = /mysql/log/binlog binlog-do-db = db1 binlog-do-db = db2 binlog-do-db = db3 **( this is not the complete config, just the relevant portions ) Additional information: The master server, got its data by replicating from the original. In this regard, even though binary logging has been turned on since the *this* master was built, the binary logs will not contain the sum total of all the transactions the db has ever seen. I can of course do a dump if I need to, but it would be much easier for me to "replicate fully on the fly" if I can, even though it will take much longer. Any advice would be great, Sean -- Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. Ambrose Bierce (1842 - 1914), The Devil's Dictionary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]