[ILUG] MySQL replication

[Nick Murtagh]

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...