Re: Trying to get MySQL to work with binlog under Windows...

check
http://mysql.com/doc/refman/5.0/en/option-files.html
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

I think it should be

log-bin=C:\Progra~1\MySQL\MySQLS~1.0\data\binlog



On my development machine, I've set it to

log-bin=mysql-bin
binlog-do-db=test

test is the database i'm replicating

the binary logs are created on the the MySQL data directory with the
filename mysql-bin.xxxxxx

xxxxxx are incrementing numbers

> Subject: > Trying to get MySQL to work with binlog under Windows...
> From: > BrainwaveSurfer <[email protected]>
> Date: > Mon, 21 Aug 2006 16:41:09 -0400
> To: > [email protected]
> 
> To: > [email protected]
> 
> Message-ID: > <[email protected]>
> MIME-Version: > 1.0
> Content-Type: > text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: > 7bit
> 
> 
> Dear All,
> 
> I've been trying to get MySQL to accept in the [mysqld] section of the
> my.ini, to start the binary logging...
> 
> 
> 
> log-bin=C:\Program Files\MySQL\MySQL Server 5.0\data\binlog
> 
> got the command from one of Russel Dyer's posts on Point-in-Time Data
> Recovery..  I've tried and tried to put it on the server service, but
> the  startup parameters field is not saved..
> 
> So, I *KNOW* it's possible, but how?
> 
> Jim

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBROudg7XBHi2y3jwfAQqbUQgAx7tT5Fk6vUYyfh2v4LEaMBPkGwFgVIDc
w/hCvFFWGtjnuAiAhIBvdh+ov/JWDzM/7RjwekrY/PeSGvlwrbdz/i+KmnFhqLrQ
rjAkCVzyzSnuFYCUm27FQqKvQSJAshnNjz7Ho6yXX34LQ6JxqYOLdf8ewVZT6xV1
zV6z2Ibh7IXDGAcQ1sh112ep9vbTDIDRnf5cWK4aMVf71lVEzjSbfrp+7wVpWI5Z
dqs9lYJkz1X945SWlUVTapJxU0o5h2r2qSPz+ZMU3YLG7SQkeUvGW7Tv3o4jOzDh
yzFLD6CeUa/UhukU+D6FOtSx1iEgu9rpUDmXtMGcAw27bI/HyuCDoA==
=MkKo
-----END PGP SIGNATURE-----