I need to replicate a database from one machine to the other in such a way
that the database is renamed on the slave. So I'd like to clone a database
"abc" to a slave system as "abc_live"
Has anyone had any experience using the replicate-rewrite-db option?? When
you use this, do you still specify the tables to replicate with
replicate-do-table?
I'm sure this will work, but I've tried a few things without luck and I
suspect its because we insert into tables using the database name (IE:
insert into database.table ....) It would seem that this might cause a
problem if you use the replicate-rewrite-db since the database name would
change?? But I'm hoping that the replicate-rewrite directive would take care
of that form you.
Please help if you can... Hearing about any working configs using
replicate-rewrite-db and what other options you specified might help me.
I'm currently using the replicate-wild-do-table=db.% in order to replicate
all tables from a database in a slave with the same name, and this is
working fine, but I can't get replication into a database with a different
name working...and I believe I must use the replicate-wild-do-table option
because of the fact that our programs always specify the database in a
select/update/insert rather than selecting a database before.
Byron Guernsey
V3 Networks, Inc.
---------------------------------------------------------------------
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
