I found the problem which I will outline here just in case anyone else
runs across it in the future:
It appears that a slave will not replicate data from it's own server-id.
In my case, a large portion of the binary logs on my slave had originally
come from the master, so when the master trie
I have one master and one slave which I am upgrading to 4.0.14 from
4.0.12. To start the upgrade I stopped the slave, took a snapshot of it's
data directory, cleared it's binary logs, and switched to the 4.0.14
binaries. I then restarted the slave thread to get it caught up with the
master.
Is your Server B using the --log-slave-updates flag?
-Mike
> Hello!
>
> I have a following system.
>
> Server A : a master for server B. MySQL 4.0.9
> Server B : a slave for server A, a master for server C. MySQL 4.0.10
> Server C : a slave for server B. MySQL 4.0.10
>
> and I wanna that if
We're having difficulties compiling MySQL on a RedHat 6.2 machine and then
installing on a RedHat 7.2 machine. This has worked in the past. The
reason for doing this is to avoid the gcc 2.96 compilation problems
indicated on the mysql.com download page.
The symptoms are that the 'make instal
I'm wondering if it's possible to specify multiple hosts for a user when
setting up permissions, but without using wildcards.
For example.. if I have these two GRANT statements:
GRANT SELECT on database.* to [EMAIL PROTECTED] identified by 'passwd';
GRANT SELECT on database.* to [EMAIL PROTECTE
Also, make sure you're running "FLUSH PRIVILEGES" after your grants and
revokes. (Did I spell that right?)
-Mike
> Hi all.
> My name is Mike.
> I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
> I want to grant access to databases and tables to users,but only to a certin
> databases and tabl
Mysql version: 3.23.53
Background: I've got a master and slave setup
and I'm switching to a new master server. In the process of switching I
need the new master to be a slave for awhile. However, after copying
over a snapshot of my data I found that mysql dies whenever the slave
thread sta
