My replication crashed just once again... my my.cnf on the slave contains: master-host = 123.123.123.123 master-user = rep master-password = hidden replicate-do-db = db1 server-id = 6 replicate-ignore-table=db1.specials I created a new DB on the master called "specials". created 100 tables on the specials called data00, data01, data02 etc. I then did a replace into specials.data10 select * from db1.specials where mynumber LIKE '10%'; on the master which works fine, but the slave crashed and I found *nothing* in mysql.err, it was empty, even after I tried "SLAVE START" several times. I then restartes thge mysql-server on the slave and did "SLAVE START" again and then found in mysql.err: ERROR: 1146 Table 'specials.data10' doesn't exist 010120 16:19:20 Slave: error running query 'replace into specials.data10 select * from db1.specials where mynumber LIKE '10%'' 010120 16:19:20 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave Of course, the the database specials and the table don't exist. they are not in the replication. I now did a mysqldump -d specials >file and created the database and tables on the slave to get the slave running again, but that's not how the problem should be solved. Is this a bug? mysql 3.23.28-gamma Thanks Jan --------------------------------------------------------------------- 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