Hi, I habe a problem with replication on mysql 3.23.31:
If I issue an ALTER TABLE command at the master, it is not send to the slaves when the table name is qualified with the database name. eg. this doesn't replicate: ALTER TABLE `database`.`ReplicationTest` ADD `einezahl` INT DEFAULT '0'; The comand doesn't appear in the slaves binlog. But if I leave out the database name, it works: ALTER TABLE `ReplicationTest` ADD `einezahl` INT DEFAULT '0' ; Because phpMyAdmin (v2.2.0) generates qualified statements, I need a solution for this problem. Any ideas? I have set "replicate-do-db=database" on the slaves. -- Rolf Herzog Programmierer Falk eSolutions AG --------------------------------------------------------------------- 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
