>Description:
Using replication and redirection. Master database named 'ftc'. Slave database named
'ftcprod'. Using replicate-rewrite-db
to direct the updates to the slave ftcprod. my.cnf is:
[cgi]# more /etc/my.cnf
[mysqld]
server-id=111757
replicate-do-db=ftc
replicate-rewrite-db=ftc->ftcprod
Also have a database named 'ftc' on the slave. Use the slave version of ftc for
development and testing.
Updates on the master are being applied to both ftc and ftcprod on the slave system.
>How-To-Repeat:
Perpetual. Updates on master are echoed.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Guy Smith
>Organization: FundTheCause
>MySQL support: none
>Synopsis:
>Severity: serious
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.32 (Source distribution)
>Environment:
System: Linux linus 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Oct 4 1996 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql-3.23.32
--with-mysqld-user=mysql
---------------------------------------------------------------------
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
