MySQL Forums
Forum List  »  Replication

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

Hello,
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?

Max

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication of single database
10863
October 04, 2005 09:21AM
5990
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.