thanks
On Wed, Aug 18, 2010 at 10:42 PM, <a.sm...@ukgrid.net> wrote:
> Quoting Norman Khine <nor...@khine.net>:
>
>
>>>
>>> What is shown from "show master status" and "show slave status" after you
>>> have made a change on the master DB?
>>
>> this is the output:
>>
>> http://pastie.org/1100610
>>
>> it does not seem to have any changes and "show slave status" is just
>> empty.
>>
>> have i missed to add something to the master's /etc/mysql/my.cnf options?
>>>
> So you can see the binlog position on the master has not changed, hence you
> wont get any changes replicated to the slave. The show slave status has to
> be run on the slave not the master.
> Anyway, I believe your problem is your binlog-do-db section on the master,
> and also the ignore sections, I think these need to be broken into seperate
> lines, with only one value per line. ie:
>
> binlog-do-db = upgrade
> binlog-do-db = tracker
this was the issue
>
> You´ll need to completely resetup the syncronsiation after this, as you
> currently have out of sync DBs and no data stored in your binlogs...
>
>
>
>
>
--
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ
ǝq s,ʇǝן ʇǝʎ
%>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or
chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] )
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
