[Gllug] mysql binary logs

[Alain Williams]

I am trying, unsucessfully, to do something that should be incredibly simple.

I am trying to switch on binary logging in mysql. I have put ''log-bin=/var/lib/mysql/''
into /etc/my.cnf in the ''[mysqld_safe]'' section and the ''[mysql.server]'' section.
I have tried variations like: ''log-bin=/var/lib/mysql/log_file_name'' and putting it
on the command line. I added ''log-bin-index=/var/lib/mysql/logbinindex''.

None of the above seems to make any difference at all. All the documentation suggests that
I am doing the right thing/

The database itself works (queries/selects) -- I just can't get the logging to appear to do anything.

I have tried this under fedora3 (mysql 3.23.58) and redhat enterprise 4 (actually: Centos 4 - but the same thing)
and with mysql mysql-server-4.1.10a.

In /var/lib/mysql I do see the ib_logfile0, ib_logfile1 & ibdata1 files - but that is something else.
Appended is a typical part of /var/log/mysqld.log.


TIA

050613 17:42:51  mysqld started
050613 17:42:51  InnoDB: Started; log sequence number 0 43681
/usr/libexec/mysqld: ready for connections.
Version: '4.1.10a'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
050613 17:50:35 [Note] /usr/libexec/mysqld: Normal shutdown

050613 17:50:35  InnoDB: Starting shutdown...
050613 17:50:37  InnoDB: Shutdown completed; log sequence number 0 43681
050613 17:50:37 [Note] /usr/libexec/mysqld: Shutdown complete

050613 17:50:37  mysqld ended


-- 
Alain Williams
Parliament Hill Computers Ltd.
Linux Consultant - Mail systems, Web sites, Networking, Programmer, IT Lecturer.
+44 (0) 787 668 0256

#include <std_disclaimer.h>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 196 bytes
Desc: not available
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20050613/f5eb3f7f/attachment.pgp>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug