I am running MySQL 5.1.47 on CentOS. How do I check if binary logging for InnoDB is active?
How do I enable binary logging if they are not enabled? Just run?
mysqld --log-bin
MySQL, check & enable binary logs
innodbMySQL
Related Topic
- MySQL – InnoDB Error: Log File ./ib_logfile0 is of Different Size
- Innodb : cannot allocate the memory for the buffer pool
- Mysql – Problems with enabling MySQL binary logging in Windows
- Mysql – How to get rid of thesql binlogs
- MySQL 5.5 InnoDB = OFF
- Mysql crashed and won’t start up
- MySQL – Unable to enable binary logging
Best Answer
Check if binary logging is active:
The key part here is
log_bin ON
but the other results can be interesting / important too.You should also see a bunch of files in your
datadir
named hostname-bin.00001. You can usemysqlbinlog <filename>
to see the queries in the binary logs.To turn it on,
mysql> SET GLOBAL log_bin = ON;
You will also want to edit your
my.cnf
so thatlog_bin = ON
the next time you restart MySQL.