replication with databases with diferent names
Hi to every one.
Wen replicating two databases with diferent names I know the option replicate-rewrite-db should be used. example:
replicate-rewrite-sb=master_mydb->replicated_mydb
And this works fine but when using PhpMyadmin on the master database a sql command would come out as this
select * from `master_mydb.table`
So replication gest a error reporting tha ther is not such database as master_mydb.
Is there a way to go arround this?
Some script that would replace the database name at the relay log before it is interpretated by MySql ??
Is there a way to force PhpMyadmin not to put database name at the sql statement??
Any help would be wellcome.
Best regards
Subject
Views
Written By
Posted
replication with databases with diferent names
1930
June 25, 2012 07:06PM
853
June 30, 2012 02:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.