MySQL Forums
Forum List  »  Replication

replication with databases with diferent names
Posted by: stelio pizzolatto
Date: June 25, 2012 07:06PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
replication with databases with diferent names
1930
June 25, 2012 07:06PM


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.