[ILUG] MySQL replication

[Mark Kilmartin]

Agh how did I miss that.

Also I guess I should use the binlog-do-db=database_name on the master
so it only logs the database in question.

Thanks for the help.

MArk


On Fri, 2002-03-01 at 14:23, Nick Murtagh wrote:
> On Friday 01 March 2002 11:59, Mark wrote:
> > The only database I want to replicate is D.
> >
> > I have looked through the mySQL documentation and done some googleing
> > but can't find how to do this.
> 
> You can't have looked very hard!
> 
>   http://www.mysql.org/documentation/mysql/bychapter/
>   manual_MySQL_Database_Administration.html#Replication_HOWTO
> 
> replicate-do-db=database_name:
> 
>   Tells the slave thread to restrict replication to the specified
>   database.  To specify more than one database, use the directive multiple
>   times, once for each database. Note that this will only work if you do
>   not use cross-database queries such as UPDATE some_db.some_table
>   SET foo='bar' while having selected a different or no database. If you
>   need cross database updates to work, make sure you have 3.23.28 or
>   later, and use replicate-wild-do-table=db_name.% Example:     
>   replicate-do-db=some_db.
> 
> > I know I could simply set up a cron job to sync the files every minute
> > or so but!
> 
> Em, I think you should let mysql take care of that stuff itself...
> 
> -- 
> Irish Linux Users' Group: ilug at linux.ie
> http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information.
> List maintainer: listmaster at linux.ie