MySQL Forums
Forum List  »  Replication

Replication of single database
Posted by: Max Regi
Date: October 04, 2005 09:21AM

is it possible to replicate only a single database in mysql?

When I create a user 'repl' on master server, giving him the REPLICATION SLAVE privilege on a single db:

GRANT REPLICATION SLAVE ON myDatabase.* TO 'repl'@'';

I obtain the following error:

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

It seems that replication slave privilege can be only global. It's so?
Any suggestion?


Options: ReplyQuote

Written By
Replication of single database
October 04, 2005 09:21AM
October 04, 2005 06:46PM

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.