Coud you, please, give an advice to solve following problem:
I've got two Mysql Servers:
* Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32
Replication of data runs fine, all "insert into" and "delete from" made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave).
Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well?
Best Regards, Kirill
--------------------------------------------------------------------- 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
