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

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

--

"Games? Solitaire? I have a 3-node VAXcluster, 4 Windows 2000 servers, 1
Windows 2003 server, 1 MySQL server, 1 *DEAD* Windows NT server, 1
*DEAD* Novell server, 1 Linux server and a direct satellite feed to my
windows desktop background, who needs toys???" - Jim


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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

Sorry, I forgot...

Windows XP, MySQL version 5.0.22 community edition..

BrainwaveSurfer wrote:
> 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
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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

--------------enigE97D0748D95D9B2F7AB61E3D
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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=3DC:\Progra~1\MySQL\MySQLS~1.0\data\binlog



On my development machine, I've set it to

log-bin=3Dmysql-bin
binlog-do-db=3Dtest

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
> Date: > Mon, 21 Aug 2006 16:41:09 -0400
> To: > win32@lists.mysql.com
>=20
> To: > win32@lists.mysql.com
>=20
> Message-ID: >
> MIME-Version: > 1.0
> Content-Type: > text/plain; charset=3DISO-8859-1; format=3Dflowed
> Content-Transfer-Encoding: > 7bit
>=20
>=20
> Dear All,
>=20
> I've been trying to get MySQL to accept in the [mysqld] section of the
> my.ini, to start the binary logging...
>=20
>=20
>=20
> log-bin=3DC:\Program Files\MySQL\MySQL Server 5.0\data\binlog
>=20
> 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..
>=20
> So, I *KNOW* it's possible, but how?
>=20
> Jim


--------------enigE97D0748D95D9B2F7AB61E3D
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----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

iQEVAwUBROudg7XBHi2y3jwfAQqbUQgAx7tT5Fk6vUYyfh2v4LEaMBPkGwFg VIDc
w/hCvFFWGtjnuAiAhIBvdh+ov/JWDzM/7RjwekrY/PeSGvlwrbdz/i+KmnFh qLrQ
rjAkCVzyzSnuFYCUm27FQqKvQSJAshnNjz7Ho6yXX34LQ6JxqYOLdf8ewVZT 6xV1
zV6z2Ibh7IXDGAcQ1sh112ep9vbTDIDRnf5cWK4aMVf71lVEzjSbfrp+7wVp WI5Z
dqs9lYJkz1X945SWlUVTapJxU0o5h2r2qSPz+ZMU3YLG7SQkeUvGW7Tv3o4j OzDh
yzFLD6CeUa/UhukU+D6FOtSx1iEgu9rpUDmXtMGcAw27bI/HyuCDoA==
=MkKo
-----END PGP SIGNATURE-----

--------------enigE97D0748D95D9B2F7AB61E3D--

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

Thank you very much, Michael!!!

Upon experimentation, long names are ok, but no spaces in directory names..

It also was not clear that one has to click the small red X in the upper
left corner of the caption for the log file name field in the MySQL
Administrator tool. I'd tried and tried, but for some reason this
morning, with you email it clicked..

Thank you again, we're up and running!!

Jim


Michael Louie Loria wrote:
> 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
>> Date: > Mon, 21 Aug 2006 16:41:09 -0400
>> To: > win32@lists.mysql.com
>>
>> To: > win32@lists.mysql.com
>>
>> Message-ID: >
>> 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
>


--

"Games? Solitaire? I have a 3-node VAXcluster, 4 Windows 2000 servers, 1
Windows 2003 server, 1 MySQL server, 1 *DEAD* Windows NT server, 1
*DEAD* Novell server, 1 Linux server and a direct satellite feed to my
windows desktop background, who needs toys???" - Jim


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org