how to enable binary logs in mysql
CentOS 5.6, MySQL 5.1.52
Test VM with fresh install of MySQL
yum groupinstall "MySQL Database"
All I did was start the server and set the root password for mysql
Now I am following How To Set Up Database Replication In MySQL and all is fine until I look for the .bin files and there are none there in:
The user mysql has read and write on the data directory
mysql> SHOW BINARY LOGS;
ERROR 1381 (HY000): You are not using binary logging
So my question is:
Is binary logging enabled as default?
How do I enable binary logging?
I have been googling this for hours and no luck
Thanks in advance
Last edited by kevmcool; 09-08-2011 at 02:44 PM.