obal grant option and is not available to database, table, column
permissions)
-Original Message-
From: John Hunter [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 11:23 AM
To: [EMAIL PROTECTED]
Cc: MySQL mailing list
Subject: Re: replication through port forwarded firewall
> "Van" == Van <[EMAIL PROTECTED]> writes:
Van> This means you need to re-initialize the slave; i.e. stop the
Van> master and slave; copy the data dir to the slave; start the
Van> slave (ensure the perms on the slave are correct first);
Van> start the master. If the error ab
John Hunter wrote:
>
> I have set up the master and slave now and am getting a problem. When
> the slave tries to connect, it appears to be attempting to enter a
> value that is already in one of my database tables, and gives the
> error:
>
> [root@newman mysql]# tail /var/log/mysqld.log
> 0203
> "Van" == Van <[EMAIL PROTECTED]> writes:
Van> No. Just have the slave connect to the master using the ip
Van> address.
I have set up the master and slave now and am getting a problem. When
the slave tries to connect, it appears to be attempting to enter a
value that is already i
Treat the master and slave as if the firewall wasn't there.
It shouldn't be any different than a router. The outside computer shouldn't
care what it is called on the internal network.
If that's not fact, then its my strong opinion :)
-Original Message-
From: John Hunter [mailto:[EMAIL PR
John Hunter wrote:
>
> I have a mysql server behind a firewall. The firewall forwards port
> 3306 requests to the server, so the outside world can use it. I want
> to replicate this database with a slave outside the firewall. So the
> slave would request port 3306 on the firewall, but get the
