Looks like we've mixed up two threads into one ;-)
As I understood from various forums and maillists, versions 4.x are
still in development state. The newest production version is 3.23.55,
am I right? Do you recommend this version for testing?
Regards,
Kirill
Egor Egorov wrote:
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
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?
Since 3.23.32 there were a lot of bug fixed related to the replication.
Please, upgrade servers and test it again.
--
Kirill Peskov
UNIX Application Engineer WEB-EU
TREND MICRO Deutschland GmbH
Lise-Meitner-Strasse 4
Unterschleissheim D-85716 Germany
Tel: +49(0)89 37479-850
Fax: +49(0)89 20 37479-700
Mobile: +49(0)172 265-1635
E-Mail: [EMAIL PROTECTED]
WWW: www.trendmicro.de http://www.trendmicro.de
The information contained in this electronic mail message and any
attachments hereto is privileged and confidential information intended
only for the use of the individual or entity named above or their
designee. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have received this
communication in error please immediately notify us by return message or
by telephone and delete the original message from your mail system.
Thank you.
-
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
