Re: Mysql database replication

2002-08-14 Thread Gerald Clark
I highly recommend you update the slave to the same version as the master. Mark D. Wallace wrote: > I'm trying to set up a replication database and cannot get the slave > to parse the log files on the master. > The slave is connecting to the master as indicated in the log file. > > I have trie

RE: MySQL Database Replication

2002-03-07 Thread Luc Foisy
-Original Message- From: Thi Cao [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:04 PM To: Thi Cao Cc: MySQL Subject: RE: MySQL Database Replication ds, If I understand you correctly, that also means that the user repl can access the mysql database where all the privilege info is

RE: MySQL Database Replication

2002-03-07 Thread Thi Cao
11:02 AM To: Thi Cao Cc: MySQL Subject: RE: MySQL Database Replication On Wed, 2002-03-06 at 14:26, Thi Cao wrote: > When I grant privileges as follows, the slave gets updated: > > GRANT FILE ON *.* to repl@'%' identified by 'some_password'; > > Could someone

RE: MySQL Database Replication

2002-03-07 Thread ds
On Wed, 2002-03-06 at 14:26, Thi Cao wrote: > When I grant privileges as follows, the slave gets updated: > > GRANT FILE ON *.* to repl@'%' identified by 'some_password'; > > Could someone please tell me why I must grant the FILE privilege on all > databases for the repl (slave) to be able to up

RE: MySql Database Replication Question

2002-03-07 Thread Thi Cao
[mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:42 AM To: Thi Cao Cc: MySQL Subject: Re: MySql Database Replication Question On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote: > All, > > How can I notify an application running on the slave server that the > slav

Re: MySql Database Replication Question

2002-03-07 Thread Jeremy Zawodny
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote: > All, > > How can I notify an application running on the slave server that the > slave database has just updated itself by means of replication. The > reason I ask is that I know MySql currently doesn't support > triggers, but my applicat

RE: MySQL Database Replication

2002-03-06 Thread Thi Cao
hanks everyone. Thi -Original Message- From: James Housley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:00 PM To: Thi Cao Cc: MySQL Subject: Re: MySQL Database Replication Thi Cao wrote: > > Hello everyone, > > This is my first attempt at MySQL database replica

RE: MySQL Database Replication

2002-03-06 Thread Thi Cao
Yes, I did flush the privileges when nothing else worked but that didn't do the trick either. Thanks for trying. -Original Message- From: James Housley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:00 PM To: Thi Cao Cc: MySQL Subject: Re: MySQL Database Replication

Re: MySQL Database Replication

2002-03-05 Thread James Housley
Thi Cao wrote: > > Hello everyone, > > This is my first attempt at MySQL database replication. Can't seem to get > it to work yet. The problem reported in the error log of the slave server > is as follows: > > Error reading packet from server: Access denied for user 'repl@slave_host' > (Usin

Re: MySQL Database Replication

2001-05-24 Thread Jeremy Zawodny
On Sat, May 19, 2001 at 01:18:42PM -0500, David Gullett wrote: > > I have 10 or so MySQL servers in the field, all writing data to a > database of the same name. I would like to set up replication from > all masters back to a single slave server and have each master write > to a different databa