Greetings All, I am using replication with one master and one slave. This evening we performed a site upgrade which involved some ALTER TABLE statements. These statements were issued on the master - on a database where one table was being excluded from replication with the replicate-ignore-table option in /etc/my.cnf on the slave. That happens to be the only table we exclude from replication. However, we do some translation of table names at the slave as well, using replicate-rewrite-db. Normally, this works fine. But after the ALTER TABLE statements were issued, things quickly fell apart. The slave stopped, reporting 'unknown table' errors regarding the table we were supposed to be ignoring. I used set SQL_SLAVE_SKIP_COUNTER=1; to skip past these statements, and eventually got to a point where the slave was saying that it didn't know about tables that weren't being ignored or re-written. I tried shutting down the slave server, renaming the 're-written' tables to their real names, changing my.cnf to comment out the rewrite options, and starting the slave again. This seemed to start things up for a short period. But eventually it stopped again on one of the queries referencing the ignored table. (The ignored table is many, many megabytes, or we would be replicating it as well). There doesn't seem to be a way out of this short of stopping both servers and copying the data again. Setup is Linux, RedHat 6.2 (actually, VA Linux with the 2.18 kernel). The machines are 733MHz PIII's. The master is running MySQL 3.23.32 and the slave is running 3.23.36. Can anyone help? Thank you, Joe Canon Accero Inc. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
