Nicole,
The tables left open warning is from the tables that were left open
when the server was rebooted. Internally mysql keeps a counter per
table of the number of clients that have a table open. When a table is
closed this counter is decremented. If mysql is improperly shutdown
this counter doe
Hi Jan,
You have two separate issues here. First the issue with the link
between the external slave and the master. Running mysql through
something like stunnel may help with the connection and data loss
issues.
The second problem is that your slave is corrupt. Duplicate key errors
are sometimes
> Date: Sat, 19 Apr 2008 20:06:49 +0200
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: mysql@lists.mysql.com
> Subject: Re: Granting users localhost access
>
> Hi Pam,
>
> If you want to grant a specific user remote access i.e. from a shell or
> from an application that resides on a
Hi Brent,
Thanks for your response. There was no other application that was writing to
slave directly. I decided to sit down and track the IDs that were being
reported as duplicates. It seems this happens with tables starting at
auto_increment at 0. Slave doesnt get replicated with records corresp
If you are getting duplicate id's on the slave, then something is not
setup correctly. The save should have the same ids as the master. Just
because a field is auto-increment, doesn't mean you can't enter you
own value. Think of auto-increment as a default value setting.
Just because a data
Thanks for all of you. I will test the suggestions and then reply.
CPK
--
Keep your Environment clean and green.
