Binary log how?

[dopaminejimmy]

hello,
i am a MySQL newbie, my MySQL server is 3.23.36 install on RH7.3.
i am trying to enable a binary log in my server recently, i give a command: 'safe_mysqld --log-bin' to enable it,
but i think it doesn't work, because i cann't find any files such as 'hostname-bin.001' or 'hostname-bin.index'.

What wrong have i done? how can i enable the binary log? Pls tell me, any reply will be appreciated, thanks

jimmy

 

[QatQat]

Have you used the mysqlbinlog command?


Try mysqlbinlog --help


anyway if you stop your server


service mysqld stop

and restart it from /etc/init.d/

./mysqld start --log-bin it should work correctly.

Bye


Qatqat

Life is what happens when you are making other plans.