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.
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!
>> 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:
>> > 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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!